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
 
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.
 
Back
Top