EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel Excel Running Total

Excel Running Total

Jeevan A Y
Article byJeevan A Y
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated May 8, 2023

Running Total in Excel

Running Total in Excel

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

Start Your Free Excel Course

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

Methods to Find Running Total in Excel

In this article, I will cover how to find running totals in Excel. There are several ways we can find the running total in Excel. Follow this article, explore each of them, and add skills 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.

Running Total Method 1-1

I have a total at the end. This gives me an overall picture of the month. But if I want to know which day 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.

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 select cell B2.

Running Total Method 1-3

  • Select the first B2 value and press the F4 key to make it 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, the first B2 cell remains constant, and the second B2 cell keeps changing with B2, B4, B5, and so on.

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

Running Total Method 1-6

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

Running Total Method 1-7

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

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 total grand 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

  • A line graph represents the total, 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 increased by 21926.

Running Total by Pivot Table in Excel – Method #2

We can find the running total by using Pivot Table as well. I use slightly different data from the daily sales tracker for this example. Data ranges 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 shown in the image below.

  • 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 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 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, to show both the running and month-wise total, add the sales amount again to the VALUES.

Total Sum

Now we have both total sums and the Running total in place.

Add Percentage Running Total in Excel.

Excel does not stop there only. We can add a total running percentage as well. To add the % 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.
  • To show the running and monthly total together, we need the sales amount column to the VALUES twice. Therefore, one will be for monthly sales and another 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 the running total in Excel, 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
All in One Excel VBA Bundle
500+ Hours of HD Videos
15 Learning Paths
120+ Courses
Verifiable Certificate of Completion
Lifetime Access
Financial Analyst Masters Training Program
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
All in One Data Science Bundle
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
All in One Software Development Bundle
5000+ Hours of HD Videos
149 Learning Paths
1050+ Courses
Verifiable Certificate of Completion
Lifetime Access
Primary Sidebar
All in One Excel VBA Bundle500+ Hours of HD Videos | 15 Learning Paths | 120+ Courses | Verifiable Certificate of Completion | Lifetime Access
Financial Analyst Masters Training Program2000+ Hours of HD Videos | 43 Learning Paths | 550+ Courses | Verifiable Certificate of Completion | Lifetime Access
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • 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

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

EDUCBA

Download Running Total Excel Template

Let’s Get Started

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

EDUCBA
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

EDUCBA

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

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

Forgot Password?

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

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