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.