Thread: Count # of Occurences
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sweepea Sweepea is offline
external usenet poster
  
Posts: 28
Default Count # of Occurences
Question:

A B
Apple Orange
Apple Pear
Apple Orange

I will like a formula to count the number of occurrences if column A=Apple
AND column B=Orange.

Please help. Thank you.

Reply With QuoteReply With Quote