counting unique numbers in filtered data

Hi, I'm trying to use the formula =SUM(N(FREQUENCY(RANGE,RANGE)>0)) to count
unique numbers which in the past has worked great, but now I'm using a
worksheet that is filtered and it's not working. Any suggestions?

Try...

=SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(Range,ROW(Range)-MIN(ROW(Range)),,
1)),Range),IF(SUBTOTAL(3,OFFSET(Range,ROW(Range)-MIN(ROW(Range)),,1)),Ran
ge))>0,1))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article <6B79C036-0A4E-4C00-ADCC-22304C5780DE@microsoft.com>,
deb <deb@discussions.microsoft.com> wrote:

> Hi, I'm trying to use the formula =SUM(N(FREQUENCY(RANGE,RANGE)>0)) to count
> unique numbers which in the past has worked great, but now I'm using a
> worksheet that is filtered and it's not working. Any suggestions?