Results 1 to 7 of 7

Thread: Formula To Sum From Movement To Cummulative Total

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    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!

  2. #2
    Member p45cal's Avatar
    Join Date
    Oct 2013
    Posts
    94
    Rep Power
    13
    Quote Originally Posted by excel_learner View Post
    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,
    in which case what you ask is impossible as there is no way to differentiate between a blank or zero being a 0 being after a final year or a blank or zero being a zero value year with more years to come perhaps
    Quote Originally Posted by excel_learner View Post
    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.
    This had already been established and is no further help.

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
  •