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
|