EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel Excel Running Total
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

Excel Running Total

By Jeevan A YJeevan A Y

Running Total in Excel

Excel Running Total (Table of Contents)

  • Running Total in Excel
  • Methods to Find Running Total in Excel

Running Total in Excel

Running Total is a form of Cumulative Sum process in Excel which is used to match the total sum obtained by using traditional SUM function or addition process with the previous cell value sum with current cell value. For example, we have 5 numbers whose sum is 100. Now to confirm whether all the values are considered in the addition process, we will sum the 2nd Value with the 1st value. Then, keep on summing the previously obtained sum and previous cells value. If Cumulative Sum and traditional sum summation come equally, then there is no cell left or no discrepancy in the selected data.

Methods to Find Running Total in Excel

In this article, I will cover the ways of finding running totals in excel. There are several ways we can find the running total in excel. Follow this article explore each one of them, and add skill to your CV.

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

Running Total by SUM Function in Excel – Method #1

We can find the running total by using the SUM function. I have sales data day-wise for one month, i.e. Jan 2018 and a few days’ data from Feb as well.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Running Total Method 1-1

I have a grand total at the end. This gives me an overall picture of the month. But if I want to know which day actually made the difference, I cannot tell with the overall sum. So I need a running total or cumulative total to tell the exact impact date.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,725 ratings)

By applying the SUM function, we can find out the running total.

  • Open the SUM function in the C2 cell and select the B2 cell.

Running Total Method 1-2

  • Now press the colon ( : ) symbol, and again select cell B2.

Running Total Method 1-3

  • Now select the first B2 value and press the F4 key to make it as an absolute reference.

Running Total Method 1-4

  • The result will be as given below.

Running Total Method 1-5

So now the first B2 cell with the dollar symbol becomes an absolute reference; when we copied down the formula first B2 cell remains constant, and the second B2 cell keeps changing with B2, B4, and B5, and so on.

  • Drag the formula to the remaining cells to get the running total.

Running Total Method 1-6

  • Now the grand total and last running total both are the same.

Running Total Method 1-7

Like this, we can get the running total by using the SUM function. In order to find the exact impact, let’s apply a cumulative graph to the table.

Select the data under the Insert tab insert Column chart.

Running Total Method 1-8

  • As soon as you insert the chart, it will look like this.

Running Total Method 1-9

  • Now select the grand total bar and select Change Series Chart Type.

Running Total Method 1-10

  • Change the chart type to LINE chart and then click Ok.

Running Total Method 1-11

  • Now the grand total is represented by a line graph, and a bar graph presents daily sales.

Running Total Method 1-12

On 16th Jan 2018, we can see the impact. On that date, revenue is increased by 21926.

Running Total by Pivot Table in Excel – Method #2

We can find the running total by using Pivot Table as well. For this example, I am using slightly different data from the daily sales tracker. Data is ranging from Jan to Dec.

Running Total Method 2-1

Let’s apply the pivot table to this data. First, apply the pivot table date-wise, as I have shown in the below image.

  • Go to Insert Tab and then click on the Pivot Table.

Running Total Method 2-2

  • Drag Date Field to Rows section and Amt to value section.

Running Total Method 2-3

  • Now group all the dates into months. Right-click on the date and select GROUP.

Running Total Method 2-4

  • Under Grouping, select Months as the option. The excel pivot table itself automatically selects starting date and the ending date. Click on OK to complete the process.

Running Total Method 2-5

  • Now we have grouped all the dates into respective months, and we have a monthly total instead of a day-wise total.

Running Total Method 2-6

  • Now right click on the column total and select Value Field Settings.

Running Total Method 2-7

  • Now under Value Filed Settings, select Show Values As.

Selecting Show Values As

  • From the drop-down list, select Running Total in and select Date as the Base Field, and then click on Ok to complete the process.

Date as the Base Field

  • We have a running total now.

Running Total

  • The problem is we do not have a total sale column here. So, in order to show both running total and month-wise total, add sales amount one more time to the VALUES.

Total Sum

Ok, now we have both total sums as well as the Running total in place.

Add Percentage Running Total in excel.

Excel does not stop there only. We can add a running total percentage as well. In order to add % running total add one more time amt column to Values.

column to VALUES

Now right click on the newly inserted column and select Value Field Settings.

Value Field Settings option

Now under this Value Field Settings, go to Show Values As. Under this, select Running Total %.

Show Value As

Finally, name this as % Running Total.

Value Field Settings

Click on Ok to complete the process. Now we have Running Total and % Running Total along with the monthly sales amount.

Sales Amount

Things to Remember

  • Running total is dynamic in the pivot table; if there is any change in the main data running total changes accordingly.
  • In order to show the running total and monthly total together, we need the sales amount column to the VALUES twice. Therefore, one will be for monthly sales, and another one is for Running Total.
  • By adding a graph, we see the impactful changes visually.

Recommended Articles

This has been a guide to Running Total in Excel. Here we discuss the methods to find running total in Excel along with examples and downloadable excel templates. You can also go through our other suggested articles to learn more –

  1. SUBTOTAL Function in Excel
  2. Address Excel Function
  3. POWER in Excel
  4. QUOTIENT in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for HR Training (8 Courses, 10+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Running Total Excel Template

EDUCBA

Download Running Total Excel Template

EDUCBA

डाउनलोड Running Total Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more