I know there is a simple way to complete the computation I am looking for, but for some reason I can't seem to come up with a solution. I need to be able to calculate the totals for each of the food types.
A B C D
1 Pizza 10
2 Hamburger 5
3 Fries 2
4 Fries 2
5 Pizza 10
6 Hamburger 5
Total Pizza:
So basically I need formula that can search column A and find all the pizzas, then add the corresponding values in column D. So the right total for this example would be 20.
Thanks for the help
Bookmarks