Don't use the Autosum Button.


Gord

On Thu, 21 Jun 2007 20:14:00 -0700, mnwild1
wrote:

Hello Gord.
I am using Excel 2007. I have manually hidden the rows I want to exclude
from the calculation but when I use the autosum, it counts the hidden rows.
How can I sum the column but not count the hidden rows?

Thank you!!

"Gord Dibben" wrote:

Which version of Excel and how are the rows hidden?

Excel 2003 has added a function that subtotals manually hidden and/or filtered
rows.

If 2003 use the formula =SUBTOTAL(109,rangetosum) to sum all hidden rows no
matter the method.

In earlier versions if rows are hidden by Filtering then use this.

=SUBTOTAL(9,rangetosum)

If an earlier version and rows are hidden manually select the range and
F5SpecialVisible cells only and OK.

Copy/paste to an unused range and sum them there.


Gord Dibben MS Excel MVP

On Thu, 21 Jun 2007 19:40:01 -0700, mnwild1
wrote:

How do I sum many rows within a column but exclude hidden colums from the
calculation?

Thank you!