Mth Apr YTD
Co A 2 53
Co B 16 32
Co C 46 103
Co D 10 89
Using these figures I was putting the formula =(B2+C2) where the figure 53
is. I solved the Circular reference I created and this worked fine. However
things go wrong when I put =(B3+C3) where 32 is located. Everytime I update
B2, where 2 is located it automatically adds another16 to C3!! Each row is a
distinct set of figures although I need to create graphs, total and calculate
percentages - hence in this format.
--
rGrant


"Max" wrote:

"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
---