• Skip to primary navigation
  • Skip to main content
  • Skip to footer
WallStreetMojo

Wallstreet Mojo

Wallstreet Mojo

MENUMENU
  • Resources
        • Excel

          • Excel Functions
          • Excel Tools
          • Excel Tips
        • Excel
        • Financial Functions Excel

          • NPV in Excel
          • IRR in excel
          • PV in Excel
        • Financial-Functions-Excel
        • Lookup Functions Excel

          • VLOOKUP
          • HLOOKUP
          • Index Function
        • Lookup-Functions-in-Excel
        • Excel Charts

          • Pareto Chart in Excel
          • Gannt Chart in Excel
          • Waterfall Chart in Excel
        • Excel-Charts
        • VBA

          • VBA Left Function
          • VBA Paste Special
          • VBA Worksheet Function
        • VBA
        • Others

          • Resources (A to Z)
          • Financial Modeling
          • Equity Research
          • Private Equity
          • Corporate Finance
          • Financial Statement Analysis
  • Free Courses
  • All Courses
        • Certification Courses

          Excel Course certificate
        • Excel VBA All in One Bundle

          Excel-VBA-Certification-Course
        • Excel Data Analysis Course

          Excel-Data-Analysis-Course
        • VBA Macros Course

          VBA-Training-Course
        • Others

          • Basic Excel Training
          • Advanced Excel Course
          • Tableau Certification Course
          • Excel for Finance Course

          • Excel for Marketers Course
          • Excel for HR Managers
          • Excel for Power Users
          • View All
  • Excel VBA All in One Bundle
  • Login

Running Total in Excel

Home » Excel » Maths Function in Excel » Running Total in Excel

By Sharmila Reddy Leave a Comment

Running Total in Excel

Running total is the total which gets updated when there is a new entry in the data, in excel the normal function to calculate the total is sum function, so if we have to calculate the running total to see how the data changes with every new entry then that means the first row reference will be absolute while others change and that is the method of calculating running total in excel.

Excel Running Total

Running Total in Excel is also called as “Cumulative” which means it is the summation of numbers increasing or growing in quantity, degree or force by successive additions. Running total in excel is basically used in determining the number of observations that lie above or below a particular value in the dataset. Cumulative tables are also used to analyze and understand a large amount of information. In this article, we will learn how to calculate the running total in excel

How to Calculate Running Total (Cumulative Sum) in Excel?

Below are the examples of Running Total in Excel.

You can download this Running Total Calculation Excel Template here – Running Total Calculation Excel Template

Example #1 – Performing “Running Total or Cumulative” with Simple Formula

Let’s assume that we have the data our expenses on a monthly basis as follows:

Running Total Example 1

From this data, we can observe that we spent 3,25,000 in total from January to December.

Running Total Example 1-1

Now, Let’s see how much of my total expenses were made by the end of the months. We are going to use a simple formula in excel to make the calculation as required.

Running Total Example 1-2

First, we should consider the amount spent in a particular month i.e. January as we are considering our spent calculation from the month of January.

Running Total Example 1-3

Now, calculate the money spent for the rest of the months as follows:

February – C3 +D2

Running Total Example 1-4

Running Total for February month is 45000.

Running Total Example 1-5

For the next month onwards we have to consider the money spent till the previous month and money spent in the current month. i.e.

March – C4+D3

Similarly, for the rest of the months and the result would be as follows:

Running Total Example 1-6

From the above result, we can observe that by the end of the year i.e. December we had spent 3,25,000 which is the total spent amount from the starting of the year. This running total will tell us how much we had spent on a particular month.

Popular Course in this category
Cyber Monday Sale
All in One Excel VBA Bundle (35 Courses with Projects) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
4.9 (1,353 ratings)
Course Price

View Course

Related Courses
VBA Macros CourseAdvanced Excel CourseTableau Certification Course

Till the month of July, we had spent 1,88,000, till November we had spent 2,94,000.

Running Total Example 1-7

We can also use this data (running total) for certain analysis.

Q1) If we want to know by which month we had spent 90,000?

  1. A) April – We can see the cumulative column from the table and it shows that cumulative spent till April month is 90,000.

Running Total Example 1-8

Q2) Suppose if we want to know the % of money spent that we had spent till July?

  1. A) 58% – We can take the amount spent till July and divide it by total amount spent as follows.

Running Total Example 1-9

We had spent 58% of money till july.

Running Total Example 1-10

Example #2 – Performing “Running Total or Cumulative” with “SUM” Formula

In this example, we will use the “SUM” function instead of the “+” operator to calculate the running total or cumulative in Excel.

Running Total Example 2

Apply the SUM Formula here.

Running Total Example 2-1

While using SUM function we should consider summing the earlier month spent and a current month spent. But for the first month, we should add earlier cell i.e. Cumulative/Running total which will be considered as zero.

Running Total Example 2-2

Then drag the formula to other cells.

Running Total Example 2-3

Example #3 – Performing “Running Total or Cumulative” with a Pivot Table

In order to perform running total using a Pivot table in excel,  we should create pivot table first. Create a pivot table by selecting the table and click on the pivot table from the Insert tab.

Running Total Example 3

We can see the pivot table is created, Now drag the month column into rows field & drag the amount spent column into values field and table would be as follows:

Running Total Example 3-1

In order to create running total value, again drag the “Amount spent” column into values field. Then right click on the column as follows:

Click on “Show Value As” and you will get an option of “Running Total As” and click on that.

Example 3-2

Now you can see the table with a column having cumulative values as follows:

Example 3-3

We can change the name of the table by editing the cell that has a Sum of Amount Spent2.

Example #4 – Performing “Running Total or Cumulative” with a Relative Named Range

In order to perform Excel running total with a relative named range, we need to do some temporary changes in the excel options.

Change Excel reference style from A1 to R1C1 from excel options as below:

Example 4 (Excel Options)

Reference style R1C1 refers to Row 1 and Column 1. In this style, we can find a positive and negative sign which are used for a reason.

In Rows: – +(Positive) sign refers to Downward direction.

– (Negative) sign refers to Upward direction.

Ex- R[3] refers to connect the cell which is 3 rows below the current cell and R[-5] refers to connect the cell which is 5 rows above the current cell.

In Columns: – +(Positive) sign refers to Right direction.

– (Negative) sign refers to Left direction.

Ex- C[2] refers to connect the cell which is 2 columns right to the current cell and C[-4] refers to connect the cell which is 4 columns left to the current cell.

In order to use the reference style to calculate running total in excel, we have to define a name with certain criteria.

In our example, we have to define name by “R[-1]C” because we are calculating the cumulative which is the sum of the previous row of the cell and column with every individual month expense. Define a name in excel with “Cum”(You can define as per your wish) as follows:

Go to Formulas tab and select define name.

Running Total Example 4-1

Then New Name window will pop out and give the name as per your wish and give the condition that you want to perform for this particular name that you defined. Here we take R[-1]C because we are going to sum the previous row of the cell and column with every individual month expense.

Example 4-2

Once the name is defined then go to the column of Cumulative/Running Total and use the defined name into SUM function as follows:

Example 4-3

This tells to perform SUM with the cell RC[-1} and Cum (Which is already defined) and in the first cell we get the same expense that incurred in the month of January.

Example 4-4

Then drag down the formula till the end of the table and we can see the cumulative results will be out as below:

Example 4-5

Things to Remember About “Running Total/Cumulative” in Excel

  • Excel Running Total/Cumulative will help in analyzing the information from the data for decision-making purposes.
  • Relatively named range type of running total is performed in order to avoid the problems with inserting and deleting rows from the data because this kind of operation will refer to the cell as per the condition given though we insert or delete rows or columns.
  • Running total/Cumulative in  Excel is mostly used in financial modeling and the final value of the cumulative will be the same as the Total Sum.
  • “Total Sum” and “Running Total” is different and the key difference is the computation we do. Total Sum will perform the sum of each number in the series of data whereas “Running Total” will sum the previous value with the current value from the data.

Recommended Articles

This has been a guide to Running Total in Excel. Here we discuss how to Calculate Running Total (cumulative sum) using Simple Formula, SUM Formula, Pivot Table and with Named Range in Excel along with practical examples and downloadable excel template. You may learn more about excel from the following articles –

  • Excel Examples of Text SUMIF
  • Excel Examples of Not Blank SUMIF
  • Examples of Chi Square Test in Excel
  • How to Change Case in Excel?
  • Using SumIf with Multiple Criteria
  • Use SUMIF With VLOOKUP
  • Use VLOOKUP with SUM
  • DSUM Excel Function
10 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Filed Under: Excel, Maths Function in Excel

Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer
COMPANY
About
Reviews
Blog
Contact
Privacy
Terms of Service
FREE COURSES
Free Finance Online Course
Free Accounting Online Course
Free Online Excel Course
Free VBA Course
Free Investment Banking Course
Free Financial Modeling Course
Free Ratio Analysis Course

CERTIFICATION COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Business Valuation Course
Equity Research Course
CFA Level 1 Course
CFA Level 2 Course
Venture Capital Course
Microsoft Excel Course
VBA Macros Course
Accounting Course
Advanced Excel Course
Fixed Income Course
RESOURCES
Investment Banking
Financial Modeling
Equity Research
Private Equity
Excel
Books
Certifications
Accounting
Asset Management
Risk Management

Copyright © 2019. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Download Running Total Calculation Excel Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.

CYBER WEEK OFFER - All in One Excel VBA Bundle (35 Courses with Projects) View More