Back,
Windows 7 Home Basic Product Key
Previous Tip from the Day
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 ,
Genuine Windows 7!
=SUM($A$2:$A2)
By Juan Pablo Gonzalez on 01-Feb-2002
MrExcel.com Consulting can be hired to implement this concept,
Office Standard 2010 title,
Buy Office Professional 2010, or many other cool applications, with your data.
MrExcel.com provides examples of Visual Basic procedures for illustration only,
Office 2007 Standard Key, without warranty either expressed or implied,
Windows Product Key, 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.