=COUNTIF(A2:A1000,"*myword*")
--
HTH
RP
(remove nothere from the email address if mailing direct)
"jen" <[email protected]> wrote in message
news:[email protected]...
> 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.
Bookmarks