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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Scott" wrote in message
...
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.