Help with Count formula

  • Thread starter Thread starter Scott
  • Start date Start date
S

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.
 
Back
Top