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