sum if (text meets condition)
 

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

sum if (text meets condition)
 

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

--
__________________________________
HTH

Bob

"Jennifer" wrote in message
...
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