By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

=subtotal xl func

The subtotal function is useful during filtering

To get the count of rows showing while filtered use

row_count = [=subtotal(3,A:A)] - 1

the "- 1: will subtract 1 for the heading

Example/