+ Reply to Thread
Results 1 to 5 of 5

Totaling multiple running totals on separate sheets

Hybrid View

  1. #1
    Registered User
    Join Date
    01-31-2011
    Location
    Austin, TX
    MS-Off Ver
    Excel 2003
    Posts
    46

    Totaling multiple running totals on separate sheets

    Hello,
    I have 6 sheets in a workbook. On 5 of the sheets, there is a running total in column AK. On the 6th sheet, I need a running total of all 5 of these running totals. Each of the 5 running totals will be added to and updated at different times (each of the five are independent of each other, and I'll need the running total on the 6th sheet to update each time any of the 5 is updated). Is this possible?

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Totaling multiple running totals on separate sheets

    Something like this?
    Attached Files Attached Files
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    01-31-2011
    Location
    Austin, TX
    MS-Off Ver
    Excel 2003
    Posts
    46

    Re: Totaling multiple running totals on separate sheets

    Almost, but there is only one column in the running total on each of the 5 sheets. So there is a column where numbers are being entered into, and then there is a running total of that column on each one. Then, on the 6th, I need the formula to total up all of those single running total columns.

  4. #4
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Totaling multiple running totals on separate sheets

    Do you have a sample workbook you could attach?

  5. #5
    Registered User
    Join Date
    01-31-2011
    Location
    Austin, TX
    MS-Off Ver
    Excel 2003
    Posts
    46

    Re: Totaling multiple running totals on separate sheets

    Sheets 1-3 have a column of data and then a column that's a running total of that data. On sheet 4, I need a running total of all 3 running totals, that will update when each one is updated, and they won't all be updated at the same time, because each one is independent.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1