title: How to count comma separated values in excel
body: <p>I have a column in excel which stores single and comma separated values. I want co count the occurrence of each value in the column even when they are in comma separated cell.</p>
  <p>E.g</p>
  <pre><code>Column A
  ----------
  1. 1
  2. 2
  3. 2
  4. 1 
  5. 3
  6. 1,2,3
  7. 1,3
  8. 1
  </code></pre>
  <p>I want to count number of &quot;1&quot; , &quot;2&quot;, &quot;3&quot; in Column A irrespective of the format</p>
  <p>When I used the <code>Countif(A1:A8, &quot;1&quot;)</code> formula, it returned 3 where I was expecting 5 including the &quot;1&quot; in row 6 &amp; 7.</p>
  <p>How do I count the values in row 6 &amp; 7 with other values?</p>