Paul Riley
New Member
- Joined
- Feb 20, 2004
- Messages
- 41
Hi,
In a large data set with auto filters I can use the function =SUBTOTAL(9,Range) to sum data only in the visble rows.
Is there a similar function to COUNT the number of visible rows when the filters are switched on & off?
Thanks,
Paul
In a large data set with auto filters I can use the function =SUBTOTAL(9,Range) to sum data only in the visble rows.
Is there a similar function to COUNT the number of visible rows when the filters are switched on & off?
Thanks,
Paul