Home |
Search |
Today's Posts |
#1
|
|||
|
|||
question about SUMPRODUCT
I have a worksheet laid out like this
COLUMN A COLUMN B manager present supervisor absent supervisor present CEO absent manager absent How would I write a formula that would count every "manager" and "supervisor" present? thanks. |
#2
|
|||
|
|||
question about SUMPRODUCT
Try...
=SUMPRODUCT(--(ISNUMBER(MATCH(A1:A5,{"Manager","Supervisor"},0)) ),--(B1:B 5="Present")) or =SUMPRODUCT(--(ISNUMBER(MATCH(A1:A5,D1:D2,0))),--(B1:B5=E1)) ....where D1:D2 contain Manager and Supervisor, and E1 contains Present. Hope this helps! In article , "nmc1104" wrote: I have a worksheet laid out like this COLUMN A COLUMN B manager present supervisor absent supervisor present CEO absent manager absent How would I write a formula that would count every "manager" and "supervisor" present? thanks. |
#3
|
|||
|
|||
question about SUMPRODUCT
Try =SUMPRODUCT(--(A1:A100="manager"),--(B1:B100="supervisor"))
The double negatives convert FALSE/TRUE to 0/1 to allow arithmetic to work best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "nmc1104" wrote in message ... I have a worksheet laid out like this COLUMN A COLUMN B manager present supervisor absent supervisor present CEO absent manager absent How would I write a formula that would count every "manager" and "supervisor" present? thanks. |
#4
|
|||
|
|||
question about SUMPRODUCT
Assuming "and" means or in this case
=SUMPRODUCT((A1:A5={"manager","supervisor"})*(B1:B 5="present")) -- Regards, Peo Sjoblom "nmc1104" wrote in message ... I have a worksheet laid out like this COLUMN A COLUMN B manager present supervisor absent supervisor present CEO absent manager absent How would I write a formula that would count every "manager" and "supervisor" present? thanks. |
#5
|
|||
|
|||
question about SUMPRODUCT
thanks! you guys are pros.
"Peo Sjoblom" wrote: Assuming "and" means or in this case =SUMPRODUCT((A1:A5={"manager","supervisor"})*(B1:B 5="present")) -- Regards, Peo Sjoblom "nmc1104" wrote in message ... I have a worksheet laid out like this COLUMN A COLUMN B manager present supervisor absent supervisor present CEO absent manager absent How would I write a formula that would count every "manager" and "supervisor" present? thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Question | Excel Discussion (Misc queries) | |||
another sumproduct question | Excel Worksheet Functions | |||
SUMPRODUCT Question... | Excel Discussion (Misc queries) | |||
sumproduct question | Excel Worksheet Functions | |||
Question about sumproduct | Excel Discussion (Misc queries) |