Results 1 to 1 of 1

Running total of multiple running totals

Threaded View

ashncg Running total of multiple... 03-09-2011, 05:20 PM
  1. #1
    Registered User
    Join Date
    01-31-2011
    Location
    Austin, TX
    MS-Off Ver
    Excel 2003
    Posts
    46

    Running total of multiple running totals

    I have a production workbook of 7 worksheets. The first is for data entry for leads and consists of various information. This info is transferred to the 6 other sheets, depending upon content. There are 5 agent sheets and one sheet for closed transactions (a total of 7).

    Now...on each of the 5 agent sheets, there are columns for financial information, including commission totals. The last columns are running totals of total production and commission. The most important is the last column on each agent sheet, called "Gregg's Commission Running Total" which totals the column titled "Gregg's Commission."

    On the closed transactions sheet, the last column is also labled "Gregg's Commission Running Total." That is because I need this column to be a running total of all 5 of the others. I need the running total for Gregg's commission on the closed transaction sheet to be like a live feed of all of his commission. The agent sheets will be updated and their totals will change independently of each other. I need the running total on the closed sheet to reflect this. If anyone needs anymore info or clarification let me know, I've attached a sample workbook. Thanks so much!
    Attached Files Attached Files
    Last edited by ashncg; 03-09-2011 at 05:35 PM.

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