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.