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!