Let’s say I have a table of what I have bought this last month.
The table has various products and
C column and
E column. How do I sum everything belonging to a certain category? For example I want how many products in category
Food I have bought. In other words
food_total = SUM(col_E)IF(col_C == "Food").