Cell Additions
 

I am wondering how to add to a previously summed number.

Example:
new price
price zone Old Price week 1 week 2 week 3 week 4 week 5
A 15.0000 15.0080 15.0100 15.0040 15.0025 15.0070
B 14.0000 14.0080 14.0100 14.0040 14.0025 14.0070
C 13.0000 13.0080 13.0100 13.0040 13.0025 13.0070
D 12.0000 12.0080 12.0100 12.0040 12.0025 12.0070
E 11.0000 11.0080 11.0100 11.0040 11.0025 11.0070
F 10.0000 10.0080 10.0100 10.0040 10.0025 10.0070

price chng week 1 week 2 week 3 week 4 week 5
week 1 0.0080 0.0020 -0.0060 -0.0015 0.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 OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200605/1