![]() |
Adding to Summed Figures
I am trying to add a number from Worksheet 1, cell C3 to a Summed Total in
Wtksht 2, 3 and 4 (same cell in each wrksht). However, want to be able to add or subtract that figure weekly to the summed total, that is the value of sum. Right now, if I change to amt in C3, previous value from that cell is now gone, therefore Summed totals in other worksheets are incorrect. example: Wrksht 1 C3 is now .03 Wrksht 2, 3 and 4 Cellhave a figure, let us say in this case 100. Have calculation in there to do the addition, 103. However if i change that value from .03 to .015 next week, I would like it to add it to the sum of 103, not 100 as it is doing. It is not retaining old summed value. Not great with excel, any help? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200602/1 |
All times are GMT +1. The time now is 05:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com