Probably this would be safer, as its not clear if 'honey' or 'cows' could appear within any cell together.

=SUMPRODUCT(N(LEN(SUBSTITUTE(SUBSTITUTE(Fundamenta ls!$B$2:$B$1000,"cows",""),"honey",""))=LEN(Fundam entals!$B$2:$B$1000)))


Regards
Robert McCurdy

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

this doesn't work...

any suggestions?

thanks very much.