software

I am wondering how to add to a previously summed number. For example, I had
.4420 .0080 .0020-.0025 .0075 - .0040 in a cell with a closing value of .
4530. Next week I would like to be able to add my change, let us use as
example .0085 to the summed figure, not having to add .0085 to the end of
the cell.

Example:
new price
price zoneOld Priceweek 1week 2week 3week 4week 5
A15.000015.008015.010015.004015.002515.0070
B14.000014.008014.010014.004014.002514.0070
C13.000013.008013.010013.004013.002513.0070
D12.000012.008012.010012.004012.002512.0070
E11.000011.008011.010011.004011.002511.0070
F10.000010.008010.010010.004010.002510.0070

price chngweek 1week 2week 3week 4week 5
week 10.00800.0020-0.0060-0.00150.0045

However I would like my spreadsheet to just be able to keep the end price of
15.0070 and add new change to that figure without to keep the 15.00 .0080
.0020 - .0060 - .0015 .0045 showing in cell.

clear as mud, I need help!!

--
Message posted via www.officekb.com