C
Copper via OfficeKB.com
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?
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?