How to count rows in a user-defined AutoFilter or AdvancedFilter is active?
 

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

How to count rows in a user-defined AutoFilter or AdvancedFilter is active?
 

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