View Single Post
  #1   Report Post  
jen
 
Posts: n/a
Default 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.