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.
|