Help with Count formula

[Scott]

I want to count the number of times two or more things appear in the same
row. For instance:

Row___A_____B_____
1 10 A
2 12 A
3 14 B
4 10 A
5 11 B

For the above example, I would like to count the number of times "10" and
"A" appear in the same row.

So the desired output should read "2".

Any ideas on how to count based on multiple search variables?

Thanks.

 

[Don Guillett]

=sumproduct((a2:a22=10)*(b2:b22="b"))

 

[Jim Thomlinson]

As a guess you will be looking for the SumProduct Formula...

=sumproduct(--(A1:A5 = 10), --(B1:B5 = "A"))

Here is a link...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html