Count visible rows in a filtered list or manual hidden rows

Count visible rows in a filtered list or manual hidden rows

The following will help to understand the steps on how to count visible rows in a filtered list or manual hidden rows

If you are in a rush and want your problem answered, email to exploresarcs@gmail.com or live chat with us.

Number of visible items in a filtered list:

=SUBTOTAL(9,A1:A100)

If you are hiding rows manually (i.e. right-click, Hide) without filtering the data:

=SUBTOTAL(109,A1:A100)

https://exceljet.net/formula/sum-visible-rows-in-a-filtered-list

About the author: admin

You must be logged in to post a comment.