Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
=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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for counting specific cells with value greater than 0 | Excel Discussion (Misc queries) | |||
Counting occurences of a specific day between two dates | Excel Worksheet Functions | |||
Counting multiple occurances of a specific string | Excel Worksheet Functions | |||
Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
how do I find an average number of specific words in a column | New Users to Excel |