=COUNTIF(C:C,"*dog*")

for column C, for example
--
Gary''s Student - gsnu200752


"JBW" wrote:

I need to count the number of times specific words appear in a sheet , I'm
not having much luck on my own as the word might be within the cell but not
constitute the whole contents.

i.e looking for the word DOG in cell containing "the dog sat down"