Learn how to create a running total in Excel with easy formulas and practical examples. Discover how to calculate cumulative sales, track expenses, use SUMIFS, and automatically update running totals with Excel Tables.
How to Create a Running Total Formula in Excel (Step-by-Step Guide)
A running total in Excel is one of the easiest ways to keep track of numbers as they change from row to row. Instead of manually adding values every time you enter a new transaction, you can use a simple formula to calculate the cumulative total automatically.
For example, imagine you maintain a monthly sales report. Every time you enter a new day's sales, you want Excel to show the total sales earned so far. A running total makes this possible without repeatedly calculating the figures yourself.
Whether you're tracking daily expenses, business revenue, employee payments, inventory, or monthly savings, Excel can calculate running totals with just a few formulas.
In this guide, you'll learn how to create a running total formula in Excel, explore practical examples, and discover how to make your calculations update automatically.
What Is a Running Total in Excel?
A running total, also known as a cumulative total, is the sum of numbers calculated progressively as you move down a list.
For example, suppose your daily sales are:
Day | Daily Sales | Running Total |
|---|---|---|
Monday | $200 | $200 |
Tuesday | $150 | $350 |
Wednesday | $300 | $650 |
Thursday | $250 | $900 |
Friday | $100 | $1,000 |
Notice how the running total increases with every new entry. Monday's sales are $200, but by Friday, the cumulative sales have reached $1,000.
This is particularly useful when you want to monitor progress without calculating the entire column manually.
How to Create a Running Total Formula in Excel
The simplest way to calculate a running total is to combine the SUM function with an expanding cell reference.
Let's create a basic example.
Suppose you have a list of daily sales in column B, starting from cell B2.
Cell | Daily Sales |
|---|---|
B2 | 200 |
B3 | 150 |
B4 | 300 |
B5 | 250 |
B6 | 100 |
Follow these steps:
Step 1: Create a Running Total Column
In cell C1, enter the heading:
Running Total
Step 2: Enter the First Formula
In cell C2, enter:
=SUM($B$2:B2)This formula calculates the total of all values from B2 to B2.
Step 3: Apply the Formula to Other Rows
Drag the fill handle from C2 down to C6.
Excel will automatically adjust the formula for each row.
For example:
Cell | Formula | Result |
|---|---|---|
C2 |
| 200 |
C3 |
| 350 |
C4 |
| 650 |
C5 |
| 900 |
C6 |
| 1,000 |
That's it! Your running total is ready. Whenever you add another sales figure, you can extend the formula to include the new row.
How to Calculate a Running Total Using a Simple Addition Formula
You don't always need the SUM function. Excel also supports a simple addition formula for calculating cumulative totals.
This method is useful when you want a straightforward calculation.
Assume your sales figures are stored in column B.
In cell C2, enter:
=B2In cell C3, enter:
=C2+B3Now drag the formula down through the remaining rows.
Excel will add the current row's sales to the previous running total.
For example:
Daily Sales | Running Total Formula | Running Total |
|---|---|---|
200 |
| 200 |
150 |
| 350 |
300 |
| 650 |
250 |
| 900 |
100 |
| 1,000 |
Both methods produce the same result. However, the SUM formula is generally more convenient when working with larger datasets.
How to Create a Running Total That Updates Automatically
If you regularly add new transactions, you may want your running total to update without manually dragging formulas every time.
One practical solution is to convert your data into an Excel Table.
Follow these steps:
Select your sales data, including the column headings.
Press Ctrl + T on Windows or use Insert → Table on Mac.
Make sure the option "My table has headers" is selected.
Click OK.
Add a new column named Running Total.
Enter this formula in the first data row:
=SUM(INDEX([Sales],1):[@Sales])Replace Sales with the actual name of your sales column if it is different.
Excel Tables automatically expand when you add new records. The calculated column formula is also filled into new rows, making this approach useful for regularly updated reports.
How to Calculate a Running Total for Monthly Expenses
A running total is not limited to sales. You can also use it to monitor household expenses, business costs, or monthly budgets.
Suppose you record your expenses in Excel as follows:
Date | Expense | Running Total |
|---|---|---|
1 November | $50 | $50 |
3 November | $75 | $125 |
5 November | $100 | $225 |
8 November | $40 | $265 |
10 November | $85 | $350 |
If your expense amounts are in column B, enter this formula in C2:
=SUM($B$2:B2)Copy the formula down the column.
Now you can see how much money you have spent up to each date.
Practical tip: Compare your running expense total with your monthly budget. This helps you identify overspending before the month ends.
How to Create a Running Total with Multiple Conditions
Sometimes you may want to calculate a running total for a particular category rather than combining every transaction.
For example, imagine you maintain a sales report containing different product categories, such as Electronics, Clothing, and Accessories.
You can use the SUMIFS function to calculate a cumulative total for one category.
Suppose:
Column A contains dates.
Column B contains product categories.
Column C contains sales amounts.
Column D contains the running total.
To calculate the running total for Electronics, enter this formula in D2:
=SUMIFS($C$2:C2,$B$2:B2,"Electronics")Copy it down the column.
Excel will add only the sales amounts belonging to Electronics up to the current row.
For example:
Category | Sales | Electronics Running Total |
|---|---|---|
Electronics | $200 | $200 |
Clothing | $150 | $200 |
Electronics | $300 | $500 |
Accessories | $100 | $500 |
Electronics | $250 | $750 |
This technique is particularly useful for business reports where you need to monitor individual product categories.
Difference Between Running Total and Grand Total in Excel
Although both calculations use addition, they serve different purposes.
Feature | Running Total | Grand Total |
|---|---|---|
Meaning | Cumulative sum up to each row | Sum of all values |
Calculation | Changes progressively | Shows the final total |
Example | $200, $350, $650 | $650 |
Main purpose | Track progress | Calculate overall results |
Common use | Daily sales tracking | Monthly sales summary |
For example, if your sales are $200, $150, and $300, the running totals will be $200, $350, and $650. The grand total will simply be $650.
Common Running Total Formula Errors in Excel
Sometimes your running total may not display the expected result. Here are a few common problems and their solutions.
Problem | Possible Reason | Solution |
|---|---|---|
Incorrect total | Wrong cell references | Check the formula range |
Same total in every row | Absolute references used incorrectly | Use an expanding range |
Formula not updating | Calculation mode is set to Manual | Change calculation to Automatic |
Zero instead of a result | Numbers stored as text | Convert text values into numbers |
Missing transactions | Formula not copied to new rows | Extend the formula or use an Excel Table |
One important detail is the dollar sign in the formula:
=SUM($B$2:B2)The $ before B2 locks the starting cell, while the ending reference changes as you copy the formula down.
This creates the expanding range required for a running total.
Best Practices for Using Running Totals in Excel
To keep your calculations accurate and easy to manage, follow these practical tips:
Use clear column headings: Name your columns something meaningful, such as Date, Sales, Expenses, and Running Total.
Keep your data organized: Avoid blank rows inside your transaction list.
Use Excel Tables: Tables make it easier to manage expanding datasets.
Check your cell references: Incorrect references can produce misleading results.
Format numbers properly: Use currency formatting for financial records.
Sort transactions carefully: A running total follows the order of your rows, so sort dates correctly when tracking transactions over time.
These small improvements can make your Excel reports easier to understand and maintain.
Frequently Asked Questions (FAQs)
1. What is the formula for a running total in Excel?
Use =SUM($B$2:B2) in cell C2 and copy it down. Excel will calculate the cumulative total for each row.
2. Can Excel calculate a running total automatically?
Yes. Convert your dataset into an Excel Table and use a calculated column formula. New rows can inherit the formula automatically.
3. What is the difference between SUM and a running total?
SUM calculates the total of a specified range, while a running total calculates the cumulative sum progressively for each row.
4. Can I calculate a running total for expenses?
Yes. Enter your expenses in one column and use =SUM($B$2:B2) in the next column to track cumulative spending.
5. Why is my running total not updating in Excel?
Check whether Excel calculation mode is set to Automatic, whether your formula references the correct cells, and whether new rows are included in the formula.
Final Thoughts
Creating a running total formula in Excel is a simple but valuable skill. It helps you monitor sales, expenses, savings, inventory, and other numerical records without repeatedly calculating totals manually.
For most everyday tasks, the formula =SUM($B$2:B2) is an excellent starting point. If you regularly add new transactions, converting your data into an Excel Table can make the process even more convenient.
Once you understand expanding cell references, you can use running totals to build more organized and useful Excel reports for personal and business purposes.


COMMENTS