Countif formula

[Mike]

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

 

[T. Valko]

Try this:

=SUMPRODUCT(--(A11=3),--(A2=D2="A"))

Biff

 

[Peo Sjoblom]

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

 

[Mike]

Thanks. This works perfectly.