View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jazzman10
 
Posts: n/a
Default If two cells have specific text to count as 1

I want to count the number of times a row has two specific words, in two
different cells eg.
If column A contains the word 'Widget' and column B contains the word 'Sale'
I want to count the number of times this occurs.

I'm sure this is easy but I've spent hours trying to get it to work.