Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2004
    Location
    Jacksonville, Florida
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cumulative calculation (9.0/2000)

    (Subject edited by HansV to match question)

    I know this is going to be simple, but my brain just took a nose dive and for the life of me, I can't figure out how to word this calculation. I have a table that I'm trying to create. I have 2 cells label Monthly expenditure and cumulative expenditure. I have the monthly cells calculated, but I want the cumulative to do just that, cumulate the amount as the months go on. Can some one please tell me the verbiage......

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cumulative calculation (9.0/2000)

    Please see the attached workbook. Column B contains monthly amounts, and column C the cumulative amounts. Cell C2 (the first one) simply copies B2, the following cells add the amount for that month and the previous cumulative total.

  3. #3
    Star Lounger
    Join Date
    Feb 2004
    Location
    Jacksonville, Florida
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cumulative calculation (9.0/2000)

    <img src=/S/newbrain.gif border=0 alt=newbrain width=21 height=22> See, I knew it was simple, my brain is "trying" to work on a more complex level!!! Thank you, it worked like a charm <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •