=SUMPRODUCT(--(A2:Z2=3),--(B3:Z3="A"))


--
Regards,

Peo Sjoblom


"Mike" wrote in message
...
I have data in a worksheet that I want it to count if it meets two points,
for example:

Row 1 3 3 2 3
Row 2 A B A A

I want it to count all instances where Row1 = 3 and Row 2=A, which should
equal 2 in this instance but I can't seem to figure out the formula. Does
anyone know how to do this? Thanks