Results 1 to 7 of 7

Thread: Formula To Sum From Movement To Cummulative Total

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #6
    Member
    Join Date
    Apr 2011
    Posts
    69
    Rep Power
    15
    Thanks, i would say it will be either blank or 0 (as it comes from another formula) saying that there was no movement in that year, but it in cumulative table should add up with last year i.e the cumulative total should remain same as last year for the year where no movement is reported. The example i have attached in "Output required" this is what is required.

    see if this helps.
    Last edited by excel_learner; 04-21-2014 at 05:11 PM.
    ----
    excel_learner
    (Using XL 2007 & 2010)

    -------Learning never stops!

Similar Threads

  1. no color in rows which have the Total or Grand Total
    By paul_pearson in forum Excel Help
    Replies: 4
    Last Post: 09-16-2013, 05:24 AM
  2. Excel Sum Formula
    By mfaisalrazzak in forum Excel Help
    Replies: 6
    Last Post: 07-26-2013, 11:42 AM
  3. Sum Of The Digits In A Cell Using Formula
    By venkat1926 in forum Excel Help
    Replies: 0
    Last Post: 04-30-2013, 07:11 PM
  4. Enter SUM SUMIFS Formula Using VBA
    By Rick in forum Excel Help
    Replies: 2
    Last Post: 02-23-2013, 07:32 PM
  5. Sum Ifs Formula needed with Max Date range
    By trankim in forum Excel Help
    Replies: 2
    Last Post: 09-19-2012, 09:50 AM

Posting Permissions

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