I believe you mean autofilter, not autosort.

Check out help on the SUBTOTAL function for working with filtered ranges.

e.g. for counting use argument of 2

=SUBTOTAL(2,range)


Gord Dibben MS Excel MVP


On Tue, 8 Mar 2011 05:28:51 -0800 (PST), Skip wrote:

I have about 500 sales entries. Using autosort, I pull out all
Mondays
(they are scattered though out the 500)
I want then to count then number of Monday entries, but the formula
counts all and my result is 500. I know this is explained poorly.
Thanks