=COUNTIF(A2:A1000,"*myword*")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jen" wrote in message
...
I am attempting to count the number of cells in a range that contain
specific
words. I can accomplish this with the =countif function, but only if my
criteria is the only text in the cell. Problem is I need to count cells
that
contain unique sentences, yet contain a single common word.