Hello,

there is a fuction in excel that can subtotal whatever we filter. Is there
any fuction in a " CountA" which can subcount what ever we filter in the
worksheet?. I tried to look up all the functions but none that can subcount
the data that we filter.

Appreciate any ideas on this.

Thanks,

Frank