About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store


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 !


By Juan Pablo Gonzalez on 01-Feb-2002 Consulting can be hired to implement this concept, or many other cool applications, with your data. provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.


Excel is a registered trademark of the Microsoft® Corporation.

All contents Copyright 1998-2008 by MrExcel Consulting.