cumulative

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!!
 
S

Sheeloo

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...
 
Top