ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Adding to Summed Figures (https://www.excelbanter.com/excel-worksheet-functions/73112-adding-summed-figures.html)

Copper via OfficeKB.com

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