cumulative

  • Thread starter Thread starter JoAnn
  • Start date Start date
J

JoAnn

Hello,

I want to put a cumulative figure on my spread sheet, but I do not know how
to do it.
The worksheet will show Current Month and also Year To Date cumulative
figures.
HELP!!
 
Let us assume that you have your monthly figures in Col A starting at A2 (A1
having the lable)

Now in B2 type this
=A2

in B3 type this
=IF(A3="","",A3+B2)

and copy it down till the row you want...
It will show nothing in Col B till you enter the figure for that row...
 
Back
Top