Hi,
I have a table like this
name category quantity
apple fruit 3
banana fruit 4
broccoli vegetable 2
oats cereals 40
chicken meat 9
spinaches vegetable 9
I want to have a total based on category, like this:
fruit 7
vegetables 11
cereals 40
meats 9
Now I'm doing it with IIF, but I have dozens of categories.