Hi

If you change your data layout slightly so that
COLUMN B = TOTAL
COLUMN C = PREVIOUS
COLUMN D = where you enter current data

in B2
=SUM(INDEX($2:$2,1,3):INDEX($2:$2,1,4))
In C2
=SUM(INDEX($2:$2,1,5):INDEX($2:$2,1,255))
Copy down as required
When you have finished entering current weeks data in column D, Insert a
new column at D to input the next week's data.

--
Regards

Roger Govier


"EXCEL Girl" <EXCEL wrote in message
...
I have 3 columns, 1 for the current amount, the 2nd for the previous
and the
3rd for the total. The following week, the current week column will
become
the previous week. Meaning I will have to move the information over to
the
2nd column and I will input new numbers into colum one for the "new
current
amount". My problem is once I change the information in colum 1, the
"total"
colum will also change. My problem is, I need this to be ongoing for
the
entire month. Hope this make sense