Try this:

=SUMPRODUCT(--(A1:A10="person"),--(B1:B10="dept"))

Or:

D1 = person
E1 = dept

=SUMPRODUCT(--(A1:A10=D1),--(B1:B10=E1))


--
Biff
Microsoft Excel MVP


wrote in message news:h_muj.39584$9j6.38777@attbi_s22...
I saw a post with this question, but it had a sumproduct function. I need
to
count the number of instances with a certain person, and from a certain
dept. I just want to count these. Is this possible?