Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using same fomula to count AND and OR options / sumproduct
Hello
I'm trying to figure out how to adapt a sumproduct formula so that i can count the number of rows where, for example, PwC is in column A New is in column B Nutrition is in column C OR Nutrition is in column D A B C D PwC New Nutition Writing Carer Return Writing Nutrition PwC New Writing Nutrition The answer should be 2 using the table above. I have been using this sumproduct fomula to count where three variables occur, but can't see how to adapt it. =SUMPRODUCT(--(B4:B87="New"),--(A4:A87="PwC"),--(C4:C87="Nutrition")) Help would be very much appreciated! KC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What are the COUNT or other options ... | Excel Worksheet Functions | |||
Count/sumproduct | Excel Discussion (Misc queries) | |||
count & If fomula | Excel Worksheet Functions | |||
Fills Series options sometimes messes the count!!! | Excel Discussion (Misc queries) | |||
Count if and Sumproduct | Excel Discussion (Misc queries) |