Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT and OR operator
I need to count the no of cells that has Col A=yes and (Either Col G or
Col H )=yes. This is somewhat different then using OR operator in the same column(like Col G=red or blue should be counted). What I want is If cell value in any of the col in same row is yes then it sould be counted. for e.g. if Row 15 has in col G yes and col H nil - counted col G nil and col H nil - not counted col G yes and col H yes - counted col G nil and col H yes - counted I hope I have clearly explained my problem. How can I do it? Regards, Madiya |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
URGENT: Please Advise. SumProduct and Operand Question | Excel Discussion (Misc queries) | |||
Adding "OR" to a Sumproduct Formula | Excel Worksheet Functions | |||
sumproduct external reference#2 | Excel Worksheet Functions | |||
sumproduct | Excel Worksheet Functions | |||
"OR" operator to evaluate multiple conditions | Excel Worksheet Functions |