Summarizing data assigned to a label

[Al Davis]

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

 

[Gary''s Student]

=SUMPRODUCT((A2:A8="Green")*(D28))
similar for other colors

 

[T. Valko]

Assume your data is in the range A28

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$8)