View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rGrant
 
Posts: n/a
Default Calculating a YTD figures from changing monthly figure.

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?
--
rGrant