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.