Try this:

=SUMPRODUCT(--(A1:D1=3),--(A2=D2="A"))

Biff

"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