sum if (text meets condition)

[Jennifer]

Hi-

In column A I have many different names with corresponding values in column
B. Q: How do add the value of column B when the name in column A is met? In
example below, I'd like to be able to total B by category A.

I hope this makes sense, thanks in advance.

Jennifer

ex.

A B
apples 100
tomatoes 500
peas 250
apples 500

 

[Bob Phillips]

=SUMIF(A:A,"apples",B:B)