title: How to Count number of text instances in excel?
body: <p>I have a table of my workdays and I want to count instances of word 'work' in each row.
  I have a table like this:
  <img src="https://i.stack.imgur.com/eT2tI.png" alt="Simple Work Sheet"></p>
  
  <p>I used this code in J1 cell but it doesn't work.</p>
  
  <pre><code>=SUM(IF(2:2 = "Sleep",1,0))
  </code></pre>
  
  <p>I have found this formula in microsoft's website but it doesn't work.
  What is causing this problem?</p>