"rGrant" wrote:
I have a column of figures in Row A (Monthly figs). I want to be able to
change these monthly figures and for it to be added to a running total in
Column B (YTD). However each time I put the formula in =(a1+b1) and =(a2+b2)
etc., the figures change all down column B whereas I only want the figs in
the corresponding cell in Column B to change. How do I stop this happening?

Just some thoughts to achieve what I think you're trying to do here ..

Assuming the 12 monthly figures are input in A2:A13,
we could pull up a "cumulative YTD" figure in B2:B13

Put in B2: =A2
Put in B3: =SUM(B2,A3)
Copy B3 down to B13

To copy the formula in B3 down, point at the fill handle
(that's the solid black square at the bottom right hand corner of B3)
then drag down to B13.

When the monthly figures within A2:A13 are changed,
col B will compute accordingly.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---