"rGrant" wrote:
Apologies - It is the cumulative effect in Column B than I am trying to
avoid. Imagine the figure in A2 is April's sales figure and B2 is the YTD
figure Jan-Apr. When I produce the sales figure for May I want to be able to
change the figure in A2 to my new figure and for this to be added to B2. I do
not want the figures in the rest of Column B to change.

well ... if I'm reading / guessing you right, it's not possible via formulas
then again, why not go with the approach suggested earlier,
where successive monthly figures are entered progressively down in A2:A13
instead of repeatedly overwriting a single source cell (A2?) with new
figures ??

Perhaps you could paste the actual formulas you have in B2, B3 & B4 (say)
so that we could have a better feel of what's happening over there <g

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---