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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating percentage growth rate from a cumulative figure 4
Cross-reference Insert Default Change 0
Find a Value the first Time It Occurs 1
Formula not being Friendly 3
Help with long if then statement 1
What is the formula for cumulative year to date totals in Excel? 2
Cumulative days roll-over 7
How do i create a cumulative worksheet 1

Top