title: Count the occurences of each unique string in a range
body: <p>I have a large range of values, with some blanks in between, and I was wondering how I could find the of total all the different values, each with their own total in that range.</p>
  
  <p>For example, I have (in the range A1:D5):  </p>
  
  <pre><code>| Low | Low | --- | Low |  
  | Low | High| --- | Low |  
  | --- | --- | --- | --- |  
  | Pie | --- | Low | High|  
  | --- | --- | Low | --- | 
  </code></pre>
  
  <p>I would like the program to spit out:<br>
  (in a range or a msgbox or anything, the user needs to write down the numbers)  </p>
  
  <pre><code>High: 2  
  Low: 7 
  Pie: 1
  </code></pre>
  
  <p><strong>What I've tried:</strong><br>
  I tried using the <code>CountIF</code> function, but have been having problems figuring it out properly.<br>
  I have well over 800 lines to test for, so I'd like to avoid iterating through every line in a simple for loop.</p>
  
  <p><strong>Bonus points:</strong><br>
  (I'd be happy with an answer to just the above, but if someone could figure this out too it would be much appreciated)<br>
  There are some cell values which compose of muliple instances of a word or even muliple words.<br>
  For example, a few cells contain</p>
  
  <pre><code>Low
  Low
  </code></pre>
  
  <p>separated only by a carriage return.
  There is even one cell in this current month that contains</p>
  
  <pre><code>Low
  Low
  High
  Low
  Low
  </code></pre>
  
  <p>I would also like to count each occurrence inside the cells, so the above cell would give the output:</p>
  
  <pre><code>High: 1
  Low: 4
  </code></pre>