Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel |