=SUMPRODUCT(--(rng1="text"),--(rng2=number))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dan Shoemaker" wrote in message
...
I would like to know how to count if 2 criterea are true in a range of
cells