Hi,

I may have misunderstood but if you simply want to add up the visible data
in a filtered list try:-

=SUBTOTAL(9,A1:A14)

If your un-filtered list is in A1-A14 put this in A15

Mike

"Frank Situmorang" wrote:

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