Counting Values in a filtered list

[KW]

Hi Guys

I've tried entering the following formula:

=SUM(IF(FREQUENCY(B2:B5,B2:B5)>0,1))

in a attempt to produce the number of unique entries in a list (which works).

Unfortunately, when I filter the list, the formula doesn't work on the remaining entries in the filtered list.

Can anyone suggest an alternative formula or tweak to the above one?

 

[Domenic]

Try...

=SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(B2:B5,ROW(B2:B5)-ROW(B2),0,1))>0,B2:B5),B2:B5)>0,1))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!