Hi
have a look at
http://www.contextures.com/xlautofilter03.html#Count

--
Regards
Frank Kabel
Frankfurt, Germany

Frank Krogh wrote:
How do I count rows in a user-defined Auto-filter on the following
columns?

ID Age Sex
123 54 male
321 76 female
432 33 male

Can I apply the same method on a predefined filter criteria (using
the
AdvancedFilter function)?

Thanks for any suggestions.


Frank Krogh