View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jennifer Jennifer is offline
external usenet poster
 
Posts: 385
Default 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