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 p45cal's Avatar
    Join Date
    Oct 2013
    Posts
    94
    Rep Power
    13
    Your example file, in cell E4, rather than showing a 0 (zero), is actually blank/empty. Curiously, cells I4 anf J4 contain 0s (zeroes) although you have those zeroes appearing as dashes.
    The difficulty lies when we encounter a cell such as G6; Is this cell showing 0 for 2013 because that year had no movement, or is there simply no value for that year? Your answer determines whether there should be a value appearing in G17 or not of your most recent file.
    Personally, I think it confusing that there should be 0 values in a cell such as I7, and years with no movement are plain blank (D7).

    Reply with how you really want the values in those cells to be and I will provide a formula.

    There is a much more complicated formula that I could give but I don't think you or I want to go down that route.

    If you reply as I expect, then the formula will be:
    =IF(ISBLANK(C4),"",SUM($C4:C4))
    Last edited by p45cal; 04-21-2014 at 04:31 PM.

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
  •