Comments on: Excel Cumulative Sum - easy way to calculate running total

Comments page 2. Total comments: 49

1. 

   Airston Tumlos says:
   2017-11-17 at 10:41 am

   i need a formula to get ending balance of today then that ending balance will be the beginning balance the next day. thank you.

   1. 

      Medic says:
      2019-11-23 at 3:50 am

      I’ve been trying to figure out how to do this as well. Have you got your answer?

2. 

   A says:
   2017-09-08 at 5:33 pm

   How do we handle when instead of sales in units ? for example the weekly budget is 130 and weekly sales for week 1 -133 week 2- 133, week 3-133 week 4- 134 week 5 -135 so whats happening here is in week 1 it will be +4 and should be +4 for week 2 and 3 because in actuality we are not selling more units. Further when we come to week 4 the increase is just 1 unit in sales so do we add 4 from prior week and 1 from current week to show 5 units or will it be 4+5 units in cummulative ? This is a case of addition but when there is a deficit vs the budget we have to add the negative units from prior period to current period so either it can net off against the surplus or add to more deficit.

   1. 

      A says:
      2017-09-08 at 5:34 pm

      Weekly budget is 129 not 130.

3. 

   Peter Bungay says:
   2017-03-07 at 5:13 am

   I have an spread sheet in excel 10 with 23 sheets and a summary sheet.

   I have a running balance set up on the 23 sheets using tables referencing system called structured references. The formula in the balance column is =SUM(INDEX([Debit],1):[(@Debit])-SUM(INDEX([Credit],1):[2Credit]).
   This produces a running balance for each sheet.

   I can get data into the summary sheet by using =[Sheet Name]![Cell]but that only references the first cell.

   What I need to know is how to get the relevant cell in the summary sheet to update as the data in the corresponding cell is changed with each input entry.

   The idea is, I start with an opening balance, enter debits or credits, a new balance is created and updated in the summary sheet. Next time I open the spread sheet I simply enter new data and the new balance is updated in the summary sheet each time I make changes.

   I trust you are able to help and I await you advice in due course.
   Peter.

   1. 

      Janet says:
      2017-03-23 at 2:27 pm

      Hi Peter,
      I am trying to do a similar thing. Did you get an answer to your question?
      Thank you,
      Janet

4. 

   Samantha says:
   2016-09-08 at 9:51 pm

   I am not skilled in excel whatsoever. Sorry. What I'm needing is to make Column A + Column B + Column C = Column D, and make it average out the sums from Column D in Column E

   1. 

      Jo says:
      2017-01-20 at 9:03 am

      For example
      In Cell D3 write:

      =SUM(A3:C3)

      fill down. Then in Cell E3 write:

      =AVERAGE(A3:C3)

      also fill down.