Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct?
Is there any way to next an "or" function within sumproduct?
I have about 1000 lines of data representing individual cases. I want to create a formula that uses 3 columns A, B and C: Return the # of cases that demonstrate a value greater than x in column A or y in column B. In addition, each must also have a "1" in column C to be included. those that have meet criteria in both column A and B should be counted only once. anand |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
sumproduct | Excel Discussion (Misc queries) | |||
Sumproduct help | Excel Worksheet Functions | |||
Sumproduct | Excel Discussion (Misc queries) | |||
HELP!!! On SumProduct | Excel Worksheet Functions |