counting specific words
 

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.

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

One way...........

Select -highlight- the cells
go to data<text to columns<
select delimited........space.........
select a new column to put the result


This will seperate all words into seperate cells
You can then use the countif function on the new area

--
Greetings from New Zealand
Bill K


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