PDA

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.

rory
09-17-2007, 05:46 AM
If the rows are hidden by a filter, you can use the Subtotal function. Otherwise you would need a User Defined Function.

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

rory
09-17-2007, 06:06 AM
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...

xld
09-18-2007, 12:54 AM
It was my error, 10,9 should have been 109, the function num to SUM excluding hidden rows.