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

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

=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

Thanks. This works perfectly.

"Mike" wrote:

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