| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: Sumif function with two sets of criteria? Can it be done?
=sumproduct((a2:a22="orgA")*(month(b2:b22)=1)*c2:c 22)
or =sumproduct(--(a2:a22="orgA"),--(month(b2:b22)=1),c2:c22) -- Don Guillett Microsoft MVP Excel SalesAid Software "Steelfan" wrote in message ... I have a spread sheet that has different organizations in column A, Dates in Column B and payments received in C. I would like to do a calculation that will add all of organizations received payments with a calendar month. I know I can do a sumif function by date and a sumif by organization name. I need to know if there is a way to do both. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF with two sets of criteria | Excel Discussion (Misc queries) | |||
| How do I add a second criteria to the SUMIF or DSUM function? | Excel Worksheet Functions | |||
| for SUMIF function, how do I use 2 sets of range & criteria | Excel Worksheet Functions | |||
| Help with SUMIF function criteria | Excel Worksheet Functions | |||
| SUMIF function - criteria of between two dates. How? | Excel Worksheet Functions | |||
Hybrid Mode
