| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Awkward sumif/sumproduct with three criteria over two ranges
sum values in sumrange if col1 = "x" OR"y" OR "z" AND col2 = "p" OR "q"
Something like this: =SUMPRODUCT(((B2:B4="x")+(B2:B4="y")+(B2:B4="z"))* ((C2:C4="p")+(C2:C4="q")),A2:A4) Do press the "Yes" buttons (like the one below) for responses which answer your questions -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF Multiple Criteria in different ranges. | Excel Worksheet Functions | |||
| Sumif with 2 ranges & 2 criteria | Excel Worksheet Functions | |||
| Sumproduct using named ranges and multiple criteria | Excel Discussion (Misc queries) | |||
| Calculate a SUMIF if criteria is between 2 date ranges | Excel Worksheet Functions | |||
| SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
Hybrid Mode
