title: Count unique values excel formula with Blanks
body: <p>I am trying to count unique values in excel by using a formula.  I have tried using the formula below but it returns a #DIV!/0 error because I have blanks in my range.  Is there anyway to count unique values in a range with blanks by using a formula? Any help with this issue would be greatly appreciated!</p>
  
  <pre><code>=SUM(1/COUNTIF(Usage!J2:J6000,Usage!J2:J6000))
  </code></pre>