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

Summarizing data assigned to a label
 

=SUMPRODUCT((A2:A8="Green")*(D2:D8))
similar for other colors
--
Gary''s Student - gsnu200813

Summarizing data assigned to a label
 

Assume your data is in the range A2:D8

F2:F4 = unique names = Red, Blue, Green

Enter this formula in G2 and copy down to G4:

=SUMIF(A$2:A$8,F2,D$2:D$8)

--
Biff
Microsoft Excel MVP


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