=SUMPRODUCT(--(A2:A200="BJ"),--(Month(B2:B200)=7),--(C2:C200="I&R"))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"E.W." wrote in message
...
I am trying to sum the number of times BJ performs I&R in july, three
variables (BJ, July, I&R). I want a real number, like it happened 5 times.
I
have it set up as a database so the social workers can just use the
drop-down
lists in the columns. This is a text count with no numbers involved. I
have a
comprehensive summary worksheet in the same workbook where I want to house
the formulas and summary functions.