Hi,

First of all, we must thank Biff for sharing this solution. This is the
formula to count the unique values in a filtered range.


=COUNT(1/FREQUENCY(IF(SUBTOTAL(3,OFFSET(A2,ROW(A3:A83)-ROW(A2),)),MATCH(A3:A83,A3:A83,0)),ROW(A3:A83)-ROW(A2)))

If this works for you, the kindly post back and thank Biff for the same.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"debl" wrote in message
...
I am trying to count items in a spreadsheet using the following formula
=SUM(IF(FREQUENCY(A3:A83,A3:A83)0,1)) when I filter the amount comes up
the
same--how can I incorporate the subtotal function in here to get a proper
number. The data in the range is week numbers that correspond with
activities
performed each day. I need to filter how many of the weeks the activity is
done.