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.

=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.

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
--
HTH...

Jim Thomlinson


"Scott" wrote:

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.