Sum of a column excluding hidden rows
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!
|