Count Occurrence of Text

[LadyDi]

I have a column in my spreadsheet that contains the call text that each technician enters about each call. I also have a list of words that I am looking for within those call texts. I have a formula the finds the words (-- =IFERROR(INDEX(SetUp!$M$2:$M$15,SMALL(IF(ISNUMBER(SEARCH(SetUp!$M$2:$M$15,$B27)),ROW(SetUp!$M$2:$M$15)-ROW(SetUp!$M$2)+1),COLUMNS($B$1:B$1))),"")--), but I would like to add a formula that counts the number of times that word appears in the call text. Is that possible? If so, how would you accomplish that? Any assistance you can provide would be greatly appreciated.

 

[Uncle Gizmo]

I would consider regeX...

http://en.wikipedia.org/wiki/Regular_expression

Can't do them myself, but on my list of things to learn, along with OOP's

 

[NBVC]

Possibly?

=SUMPRODUCT(COUNTIF(B27,"*"&Setup!$M$2:$M$15&"*"))