| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum cells based on two criteria
I need a total (count) broken down by user (name) and month. What formula can
I use to achieve this? SUMIF only allows 1 criterion, whereas I have two (name and month). A2 = Count B2 = Name C2 = Month EXPECTED RESULTS: Jan Feb Mar Smith 20 4 15 Jones 16 12 19 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count cells based upon criteria in other cells | Excel Worksheet Functions | |||
| Fill cells with color based on criteria in two cells | Excel Worksheet Functions | |||
| SUM cells together based on 2 criteria | Excel Worksheet Functions | |||
| copying cells based on criteria | Excel Worksheet Functions | |||
| sum cells based on multiple criteria | Excel Programming | |||
Threaded Mode
