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.

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

**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?

Originally Posted by xld

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.

Thread: Solved: sum visible rows only