View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David F Cox David F Cox is offline
external usenet poster
 
Posts: 37
Default Count Cells That Don't Contain the Following Text Strings

If I read this right it will count all records that have neither Honey or
cows in the text

I think it is equivalent to NOT AND("=*honey*","=*cows*"))

since you have not told us what you want I have no suggestions.


"SteveC" wrote in message
...
=COUNTIF(Fundamentals!$B$2:$B$1000,OR("<*honey*", "<*cows*"))

this doesn't work...

any suggestions?

thanks very much.