Let’s say I have a table of what I have bought this last month.
The table has various products and Category
in C
column and Quantity
in 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")
.