Budgets- How to get a sub-total from multiple sheets?

[manyhats]

I am sure this is something that is simple, but I have not worked with Excel in many years. Could someone please tell me what the formula is that I use to give me a sub-total of all my totals that are on individual sheets. ex: I have sheet1-9 with sheet 3 deleted, each of these sheets in my workbook has a total of purchase prices in the E34 cell. How do I use one of the cells in an existing page to add up all of the totals in each sheet in cellE34 and give a subtotal?
Thank you abundantly!

 

[Juan Pablo González]

You could use a 3D cell reference, something like:

=SUM(Sheet1:Sheet9!E34)

This would add everything between Sheet1 and Sheet9.

 

[manyhats]

Thank you for your help, I had used that formula and it was working fine but apparently I had created an error in one of my totals by including the cell that the total was in. Make sense? Well, thanks for the voice of rejuvenation.