View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
 
Posts: 698
Default Count Cells That Don't Contain the Following Text Strings

If I understand correctly, this may do what you want.

=COUNTA(D1:D10)-(COUNTIF(D1:D10,"honey")+COUNTIF(D1:D10,"cows"))

Change the D1:D10 to yours.

HTH
Regards,
Howard

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

this doesn't work...

any suggestions?

thanks very much.