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.
|