Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summarizing data assigned to a label
=SUMPRODUCT((A2:A8="Green")*(D2:D8))
similar for other colors -- Gary''s Student - gsnu200813 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing data by assigned ID | Excel Discussion (Misc queries) | |||
Summarizing Data | Excel Worksheet Functions | |||
summarizing data | Excel Worksheet Functions | |||
How to rezize data label box in pie charts (label wraps to two lin | Charts and Charting in Excel | |||
Summarizing data | Excel Discussion (Misc queries) |