title: How to count number of times specific word occurs in a range in MS Excel?
body: <p>I am analyzing data having 450000 cells in a column range which is taking a long time to find occurrences of a specific word hence hanging Excel. The formula I am using is <code>=SUMPRODUCT(LEN(range)-LEN(SUBSTITUTE(range,word,&quot;&quot;)))/LEN(word)</code></p>
  <p>Please help me on this query.</p>