View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Al Davis Al Davis is offline
external usenet poster
 
Posts: 1
Default Summarizing data assigned to a label

I have a table of information, like this one...
Name Box Bag Total
Red 12 8 20
Blue 3 3 6
Green 41 41 82
Red 2 19 21
Blue 16 3 19
Green 1 8 9
Green 1 5 6

I want to get a some for each name
That is...
I'd like to get the total of
Green Items
Red Items
Blue Items
Each one has a total of items at the right; I'm trying to get the total for
each Name in the table.

Thanks,
Al Davis