adding a cell to a total if the cell value next to it is of a specific type

Well..Im not really sure how to search for that so i figured I'd ask. Its been a long time since ive used excel and know theres a way to do it but cant rember for the life of me how.

Basically I have a sheet like this

Please Login or Register  to view this content.

I need a way to see if the cell value in row a is cheese. If it is cheese then it sums row b for every cheese in row a. in this case it would be b1+b3+b5. Because cheese is in a1, a3 and a5 Thanks for any help.. Or point me in the right direction!
Chris

Either of these functions should do the trick for you.

=SUMPRODUCT(--(A1:A7="cheese"),B1:B7)

=SUMIF(A1:A7,"cheese",B1:B7)

Hope that helps.

Awesom!! Thanks for the quick reply.. That was it

No problem, thanks for the feedback.