Thursday, September 19, 2013

yogi_Count Instances Of A Specified String (Word or Phrase) In A Range Of Cells

                                          Google Spreadsheet   Post  #1374
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Sep 19, 2013
user Sandy Joe (!category-topic/docs/spreadsheets/DXbul9-gIYY)
How can I count the occurrences across a range of cells of a word within a paragraph
I would appreciate any help on how to do this since I've been racking my brains and searching like crazy on an easy way to accomplish this.  Basically, I have multiple columns of data where each cell contains a paragraph of text.  I would like to get a count of the number of occurrences for a specific string contained within the paragraph.  For example, if the string I'm looking for is "class" then for a defined range of cells, I would like to get a count of how many times this string appears.  For any given cell, this string could appear multiple times.