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
Similar Threads
