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

manyhats · May 2nd, 2002, 11:02 AM

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 · May 2nd, 2002, 11:06 AM

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

=SUM(Sheet1:Sheet9!E34)

This would add everything between Sheet1 and Sheet9.

manyhats · May 2nd, 2002, 12:04 PM

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.

May 2nd, 2002, 11:06 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	You could use a 3D cell reference, something like: =SUM(Sheet1:Sheet9!E34) This would add everything between Sheet1 and Sheet9. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 11:02 AM	#1
manyhats New Member Join Date: May 2002 Posts: 2	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!

May 2nd, 2002, 12:04 PM	#3
manyhats New Member Join Date: May 2002 Posts: 2	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.