View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scott scott is offline
external usenet poster
 
Posts: 577
Default Help with Count formula

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.