I want to count how many rows are left in the worksheet after I used filter
and some rows had been hidden. COUNTA give me all rows and not the one after
filter.
Are there any function can do that or need to use VBA?
Thank you.

hi, anonymous !

> I want to count how many rows are left in the worksheet after I used filter and some rows had been hidden.
> COUNTA give me all rows and not the one after filter.
> Are there any function can do that or need to use VBA?

subtotal(... worksheet-function only tracks visible cells/rows after any autofilter criteria so...

counting numbers: =subtotal(2,<filtered range>)
counting text/any: =subtotal(3,<filtered range>)

hth,
hector.

Hello,
Thank you. It work out good. I know subtotal can sum but forget/not realize
it can do counting etc too.

Thanks a lot.
Learn-more

"Héctor Miguel" wrote:

> hi, anonymous !
>
> > I want to count how many rows are left in the worksheet after I used filter and some rows had been hidden.
> > COUNTA give me all rows and not the one after filter.
> > Are there any function can do that or need to use VBA?
>
> subtotal(... worksheet-function only tracks visible cells/rows after any autofilter criteria so...
>
> counting numbers: =subtotal(2,<filtered range>)
> counting text/any: =subtotal(3,<filtered range>)
>
> hth,
> hector.
>
>
>