+ Reply to Thread
Results 1 to 5 of 5

Running totals

Hybrid View

JimDandy Running totals 06-11-2012, 04:57 PM
MarvinP Re: Running totals 06-11-2012, 05:09 PM
JimDandy Re: Running totals 06-11-2012, 05:39 PM
Cutter Re: Running totals 06-11-2012, 05:10 PM
Fotis1991 Re: Running totals 06-11-2012, 05:11 PM
  1. #1
    Forum Contributor
    Join Date
    11-17-2004
    MS-Off Ver
    Office 2016
    Posts
    527

    Running totals

    I have a series of values that I’d like to perform a running total on. There are multiple values across the top in Row 1 starting at Column B. In the cells beneath, I’d like to calculate the running total of the values in the cell above, plus any to the left of that cell, but not to include Column A. I could create a unique formula for each cell, but I'm looking for a formula that I can copy across Row 2

             A     B     C     D     E     F     G
       1   Val    12    10    15    12     6    12
    
       2   Tot    12    22    37    49    55    67

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,234

    Re: Running totals

    In Cell B2 put this formula and pull it across
    =SUM($A1:B1)
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor
    Join Date
    11-17-2004
    MS-Off Ver
    Office 2016
    Posts
    527

    Re: Running totals

    Wow, it was that simple I couldn't see it...many thanks for the quick response, much appreciated.

    Quote Originally Posted by MarvinP View Post
    In Cell B2 put this formula and pull it across
    =SUM($A1:B1)

  4. #4
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Running totals

    In B2 would be: =B1
    In C2 would be: =IF(C1="","",SUM($B1:C1) and drag across

  5. #5
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Running totals

    Hi

    In B2

    =B1

    In C2 and copy cross.

    =C1+B2
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

+ 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