counting numbers if certain criteria are met?

[judoist]

I have two columns. the first has single digits between 0 and 9, th
second has x's with blank spaces in between. Anyone know how to count
or mark all the 2's in the first column that also have an x in th
second column? Don't want to just count ALL the 2's

 

[Andy B]

Hi

Try something like this:
=SUMPRODUCT((A2:A1000=2)*(B2:B1000="x"))

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(A1:A100=2),--(B1:B100="x"))

 

[judoist]

Awesome !

Thanks guys.

Natha