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.