Counting rows in filtered spreadsheet?

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
 
K

Ken Wright

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.
 
A

Andrew

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