=SUMPRODUCT(--(A5:A10="X"),--(B5:B10="C"))

--
HTH

Bob Phillips

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

"kmason" wrote in message
...
I want to count all the X's in Cells A5:A10 if there is a C in Cells
B5:B10.
Can someone help? Thanks