Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct-multiple criteria for same range "OR"
I found a solution to my problem....
However, to designate "or" between multiple conditions existing in a *single* range, you can create an array of these "or" conditions, using an array constant, as: =Sumproduct((Range1-{Condition1,Condition2,Condition3})*( ... )). The above solution works IF I type in the conditions which are text...so when I type in "Condition1" in quotes and "Condition2" in quotes it works as I want it as an OR statement. However, when I try to put a cell reference as the conditions where the cell reference is the actual text condition...it does not work. Can anyone help? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return multiple rows of data based on criteria | Excel Worksheet Functions | |||
Dynamic range names, multiple criteria, sumproduct | Excel Discussion (Misc queries) | |||
Using Sumproduct with multiple Criteria | Excel Worksheet Functions | |||
Sumproduct with a vLookup, multiple criteria | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |