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 <[email protected]>,
deb <[email protected]> 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?