In case of the Sumif function has a following structure SUMIF(range, criteria
, [sum_range]). "Criteria
" in this case is a condition or expression like "summer" or ">10" etc.
In my application I could have categories like
and I want to sum each of the categories, but I do not want to fill in each of the criteria
in seperate sumif functions. I want to paste the Sumif function next to each category in this list and the "criteria" in the formula must refer to the category next to it
, instead of being hard coded.
Is there a way to do it?
I hope some clever dude will understand my question.