I am trying to add up a column of numbers but I have hidden rows in the
spreadsheet and don't want to include them in the sum.
How were the rows hidden?
What version of Excel?
In Excel 2003 (and I assume later), you can use the function:
=SUBTOTAL(109,rng) where range is the reference to the cells. Hidden rows
will not be included in the sum.
For earlier versions of Excel, SUBTOTAL(9, rng) will not include rows that were
hidden as the result of a filter. (I'm really not sure about Excel 2002,
though).
--ron