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").
to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.