Sumif Function where "criteria" refers to the contents of a cell.
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
Is there a way to do it?
I hope some clever dude will understand my question.
In my application I could have categories like
apple
pear
grape
orange
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.pear
grape
orange
Is there a way to do it?
I hope some clever dude will understand my question.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I somehow just could not get it right.
Thanks a lot.