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
|