| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Criteria based sum question
I have data in the following format
Resource Type Resource Project Regular 10 A Regular 20 A Contractor 05 A Regular 10 B Contractor 15 B How would I find the sum of all resources (regular and contractor) for project A, B, C etc. Which formula do I use? And then sum of regulars for project A, B, C etc. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return multiple rows of data based on criteria | Excel Worksheet Functions | |||
| Delete rows based on criteria | Excel Discussion (Misc queries) | |||
| how to count unique values in excel based on multiple criteria | Excel Worksheet Functions | |||
| Locate a Cell based upon criteria | Excel Discussion (Misc queries) | |||
| counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
Threaded Mode
