Running totals

[Joe]

Hi All

How can I get excell to keep a running total?

A1= 0 , enter 50, A1 now = 50. Next time A1= 50 enter 50 again A1 now = 100

Is it even possible ?

TIA. Joe

 

[J.E. McGimpsey]

Take a look at

http://www.mcgimpsey.com/excel/accumulator.html

 

[Joe]

Tnx J.E.
I'm Not good with macros yet but this served the purpouse

Worksheet Function Accumulator (using Circular References)
A two cell accumulator can also be constructed without VBA using circular
references. To avoid an error, first choose Tools/Options/Calculation (Mac:
Preferences/Calculation) and check the Iterations checkbox. Enter 1 in the
number of iterations box. Now enter the following

B1: =A1 + B1

B1 will immedately take on the value of A1, then will update every time A1
is changed (or the entire worksheet is calculated). Note that it is very
difficult to clear this accumulator - deleting the value in B1 deletes the
formula. One can either enter the negative of B1 or edit the cell.


The only thing I have to be carefull about is that after B1 is Added to A1
the value in B1 has to be removed or it will be added on Save Open Or on any
other calculation. otherwise its perfect. Know of anywhere I could learn
about installing Macros ?

 

[J.E. McGimpsey]

Check out David McRitchie's site:

Getting Started with Macros and User Defined Functions
http://www.mvps.org/dmcritchie/excel/getstarted.htm