| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct on multiple "or" conditions
Thanks, that works the best. I have multiple conditions, so the prior does
not work. "Harlan Grove" wrote: "Rick Rothstein (MVP - VB)" wrote... .... =SUMPRODUCT((ID={1340,5450})*Amount) Which is the best way to do it in this case since ID could only equal one or the other. More generally, multiple OR conditions could be true, in which case you'd need =SUMPRODUCT(--((Condition1)+(Condition2)+...+(ConditionN)0),val ues) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct, multiple conditions.. but I also want to "minus" somet | Excel Worksheet Functions | |||
| SUMPRODUCT(--ISNUMBER(FIND("AM",C5:160))*(k5:k160="") | Excel Discussion (Misc queries) | |||
| Sumproduct-multiple criteria for same range "OR" | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Please, need help with multiple "if" conditions | Excel Discussion (Misc queries) | |||
Threaded Mode
