Calculating without including Hidden Cells
 

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

Have a look in HELP index for SUBTOTAL

--
Don Guillett
SalesAid Software

"LiquidFire" wrote in message
...
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

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

"LiquidFire" wrote in message
...
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

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

LiquidFire wrote:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html