Calculating without including Hidden Cells

[Guest]

PLEASE HELP

I have a 30 page excel worksheet that I need to get a sum for. I have
hidden the cells that don't need to be included in the total, but I need to
keep them in the work- sheet. How do I calculate these cells without having
to delete them. I thought about copy/pasting them into another worksheet to
see if they would come without the hidden cells, but thought their had to be
an easier solution?

Please help...Thanks in Advance

 

[Don Guillett]

Have a look in HELP index for SUBTOTAL

 

[Paul B]

LiquidFire, use subtotal, something like this

=SUBTOTAL(109,A1:A5000)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Debra Dalgleish]

If you have Excel version 2002 or earlier, you can use the Subtotal
function to sum the cells that are visible after a filter has been
applied to a list. For example, =SUBTOTAL(9,A2:A200)
would sum the visible filtered cells in column A.

However, if you manually hide the rows, the SUBTOTAL function will sum
all the cells, including the hidden ones.

If you have Excel 2003, you can ignore values in filtered and manually
hidden rows, by changing the first argument in the SUBTOTAL function.
For example: =SUBTOTAL(109,A2:A200)
would sum only the visible cells in column A