I have 2 data columns. In column A, the data is updated every day so
that the bottom cell of the column contains the new daily data.

eg:

DAY

1
2
3
4
5

So as each day goes by, the earliest day (day #1) gets dropped and I
only have data for the 5 previous days. What I want is to keep a record
of the data that I delete. So I want to keep a running total of all the
data entered through all the days. So if I delete day #1 data, I can
ensure that it gets kept on a running sum. For example, let's say the
data looks like this:

DAY DATA

1 4
2 5
3 6
4 7
5 8

So the running total of the data is (4+5+6+7+8) 30. So when tomorrow
comes, I will delete day #1 data and move day 2-5 data back, so new
data gets entered into day 5. That means that 4 in my data table will
be erased and the new sum will not be 30. How can I keep a running
total of all old and new data entered in that column?

In old programming software I would simply put sum=sum+x. This would
automatically keep record of the old sum and add the new entered data.

Anybody know how this works in Excel?


--
leafsfan1967
------------------------------------------------------------------------
leafsfan1967's Profile: http://www.excelforum.com/member.php...o&userid=24357
View this thread: http://www.excelforum.com/showthread...hreadid=384411