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

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

Access YTD - Form 0
Calculating percentage growth rate from a cumulative figure 4
How do i create a cumulative worksheet 1
Find a Value the first Time It Occurs 1
What is the formula for cumulative year to date totals in Excel? 2
Sum multiple cells based on vlookup 1
cumulative totals in a workbook 1
HELP ON SUM - REQUIRED 8

Back
Top