Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

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

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    New Member
    Join Date
    May 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •