How to Create a Running Total Formula in Excel (Step-by-Step Guide)

Learn how to create a running total formula in Excel using SUM, SUMIFS, and Excel Tables with simple examples to track sales, expenses, and more.

How to Create a Running Total Formula in Excel (Step-by-Step Guide)

   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

=SUM($B$2:B2)

200

C3

=SUM($B$2:B3)

350

C4

=SUM($B$2:B4)

650

C5

=SUM($B$2:B5)

900

C6

=SUM($B$2:B6)

1,000


How to Create a Running Total Formula in Excel (Step-by-Step Guide)

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:

=B2

In cell C3, enter:

=C2+B3

Now 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

=B2

200

150

=C2+B3

350

300

=C3+B4

650

250

=C4+B5

900

100

=C5+B6

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:

  1. Select your sales data, including the column headings.

  2. Press Ctrl + T on Windows or use Insert → Table on Mac.

  3. Make sure the option "My table has headers" is selected.

  4. Click OK.

  5. Add a new column named Running Total.

  6. 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

Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content