| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif for groups and subgroups / Excel 2003
I'm trying to sum a row if it meets two different criteria. Here's an
example. Here I would try and add column C if column A was 123 and column B was group A. Or something similar. I tried to used sumproduct (reading other responses to similar questions) but I get #NUM! error. Any ideas? A B C 1 123 group A 5 2 456 group D 10 3 123 group B 14 4 456 group A 7 5 123 group C 6 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating averages for subgroups | Excel Discussion (Misc queries) | |||
| Ranking within subgroups | Excel Discussion (Misc queries) | |||
| Ranking Subgroups that are above 750 | Excel Discussion (Misc queries) | |||
| Excel 2003 Much Slower When Opening Row Groups | Excel Discussion (Misc queries) | |||
| how do i view all groups under excel in google groups | Excel Discussion (Misc queries) | |||
Threaded Mode
