MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Running Total in Adjacent Cell


February 01, 2002 - by Juan Pablo Gonzalez

Murray asks:

I want to keep a running total of the numbers I put in a column. For example in col A I have 12 15 12 16 22 14 11 etc. In col B I want the total of 12+15 then 12+15+12 then 12+15+12+16.......12+15+12+16+22+14+11=99. I tried using the E(sum sign) but I would have to repeat each time I entered a number in Col A. I would like to be able to copy the formula in COL B as far as the worksheet allows and as numbers are entered in COL A the total will show as I go.

If the data starts in Row 2, then put this formula in B2 and drag down!

=SUM($A$2:$A2)