Running Total in a cell.

  • Thread starter Thread starter picktr
  • Start date Start date
P

picktr

As I change the numbers in each of 4 given cells,
I would like the 5th cell, holding the sum of the other 4 cells,
to keep a running total.

ex: cell a1 today input 2, and the other 3 cells also 2
for a total of 8 showing in the 5th cell

tommorrow I change the four cells numbers to 3, 6, 6, 4.
for a total of 19 but the 5th cell should show 27

Any help would be appreciated.

Tom Pickett, (e-mail address removed)
 
Take a look at

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

For the two cell accumulator (assuming input cells are A1:D1 and total
is in E1, change

If .Address(False, False) = "A1" Then

to

If Not Intersect(.Cells, Range("A1:D1")) Is Nothing Then

and change references to B1 to E1.

Be sure to read the 1st paragraph - using an accumulator this way, in my
experience, is nearly always unsuccessful in the long run since you lose
the history - if you ever make a mistake, it can be very difficult to
recover. It's much easier to add a row of data every day and use
something like

=SUM(A:D)

to keep your running total. You can hide previous rows if you want.
 
Back
Top