View Full Version : Solved: sum visible rows only
jammer6_9
09-17-2007, 05:43 AM
How can I sum visble rows then exclude hidden rows in my calculation.
If the rows are hidden by a filter, you can use the Subtotal function. Otherwise you would need a User Defined Function.
Bob Phillips
09-17-2007, 05:50 AM
In Excel 2003, extra functon nums were introduced, so you can use
=SUBTOTAL(109,rng)
to exclude rows hidden manually.
Good to know - I knew there were additional ones in 2007, but did not know about 2003. Thanks.
jammer6_9
09-17-2007, 11:46 PM
Whats that 10,9 used for?
In Excel 2003, extra functon nums were introduced, so you can use
=SUBTOTAL(10,9,rng)
to exclude rows hidden manually.
jammer6_9
09-18-2007, 12:43 AM
Sorry I got it... Reading on the Help menu clears me out. Thanks for the Idea or formula...
Bob Phillips
09-18-2007, 12:54 AM
It was my error, 10,9 should have been 109, the function num to SUM excluding hidden rows.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.