title: Count occurrences of values or unique values in a data range
body: <p>There's a formula that is so useful to me on <a href="http://office.microsoft.com/en-us/excel-help/count-occurrences-of-values-or-unique-values-in-a-data-range-HP003056118.aspx" rel="nofollow">http://office.microsoft.com/en-us/excel-help/count-occurrences-of-values-or-unique-values-in-a-data-range-HP003056118.aspx</a></p>
  
  <p>It's this:</p>
  
  <pre><code>=SUM(IF(FREQUENCY(MATCH(B2:B10,B2:B10,0),MATCH(B2:B10,B2:B10,0))&gt;0,1))
  </code></pre>
  
  <p>Which is described on its site as: 
  "Count the number of unique text and number values in cells B2:B10 (which must not contain blank cells)"</p>
  
  <p>My problem is I need it to allow for blank cells interspersed in the range, but just not count those.</p>
  
  <p>Thank you for any help.</p>