<div>
=SUM(IF(ISBLANK(A1:A200),0<wbr />,1/COUNTIF<wbr />(A1:A200,A<wbr />1:A200)))<br />
assuming your data is from a1 to a200 &nbsp; feel free to change the range in formula<br />
enter with Control + Shift + Enter
</div>


=SUM(IF(ISBLANK(A1:A200),0,1/COUNTIF(A1:A200,A1:A200)))
assuming your data is from a1 to a200   feel free to change the range in formula
enter with Control + Shift + Enter

<div>
and with your original frequency function &nbsp;here is the formula<br />
<br />
enter with control shift enter<br />
<br />
=SUM(IF(FREQUENCY(IF(LEN(A<wbr />1:A200)&gt;0,<wbr />MATCH(A1:A<wbr />200,A1:A20<wbr />0,0),&quot;&quot;), IF(LEN(A1:A200)&gt;0,MATCH(A1<wbr />:A200, A1:A200,0),&quot;&quot;))&gt;0,1))
</div>


and with your original frequency function  here is the formula

enter with control shift enter

=SUM(IF(FREQUENCY(IF(LEN(A1:A200)>0,MATCH(A1:A200,A1:A200,0),""), IF(LEN(A1:A200)>0,MATCH(A1:A200, A1:A200,0),""))>0,1))

<div>
Solution resolves issue. Thanks!!
</div>


<div>
<div class="content wysiwyg-content">
I'm using this formula: =SUM(IF(FREQUENCY(A1:A200,<wbr />A1:AD200)&gt;<wbr />0,1)) to count unique numbers in column A.<br />
<br />
I noticed that if a letter(s) proceed numbers it does not count. I'm assuming this is correct for this function.<br />
<br />
Is there a way to modify the formula to count unique &quot;cells&quot; if either numbers or letters? or another solution all together.<br />
<br />
Thanks
</div>
</div>


I'm using this formula: =SUM(IF(FREQUENCY(A1:A200,A1:AD200)>0,1)) to count unique numbers in column A.

I noticed that if a letter(s) proceed numbers it does not count. I'm assuming this is correct for this function.

Is there a way to modify the formula to count unique "cells" if either numbers or letters? or another solution all together.

Thanks

Frequency Function

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.