View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JRD JRD is offline
external usenet poster
 
Posts: 60
Default Counting cells that don't contain certain text

Is there a quick and easy way of counting the number of cells that don't
contain certain text strings

For example

Column A

Yes
No
Yes
Maybe
Maybe
No
Certainly
Definately
Yes

How could I count the number of cells that don't contain the word "yes" - in
this case the answer would be 6

Many thanks