Counting rows in filtered spreadsheet?

  • Thread starter Thread starter sisco
  • Start date Start date
S

sisco

I have a spreadsheet with filters to allow me to view different queries
on the data. Is there a quick way to find out the number of rows once
filters have been applied.

Numpty question but frustrating to find answer. Any help appreciated.

Sisco
 
One way

=SUBTOTAL(3,A2:A1000)

will count visible rows when you apply a filter
 
And if you have Excel 2003 you can also use the new optional arguments to count
visible rows after hiding rows as well, not just filtering them.
 
Wow, I never knew about that SUBTOTAL function. That's great!

I like how you can define the Function to calculate stuff like Average
etc. Work really well with a Combo Box if you want to present different
kinds of data but you only had limited space.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide rows function 4
Numbering rows with filters 1
How to filter rows data based on background color of individual cells 1
Dynamic Filtering 2
remove advanced filter on a spreadsheet 1
Copy and pasting values of filtered rows 1
What is the maximum filter for rows? 1
Excel 2007 compatibility issue - speed between cells 2

Back
Top