top of page
Writer's pictureRachel | The Blue Star Academy

Microsoft Excel - Calculate a Running Total using the SUM Function

If you want to find out the running total, aka the cumulative sum of a set of figures, then this tutorial is for you.


You can download the Microsoft Excel file below to try this tutorial out for yourself.

 

A running or cumulative total is basically a calculation that grows over time. By providing a complimentary calculation column next to your data, you will be able to easily show growth (or decline). Follow the steps below, using the downloadable file above, to try it for yourself.


It uses the SUM function in partnership with some clever cell addressing.


  1. In cell D3, start by typing in =SUM(

  2. After the opening parentheses (the bracket), click on cell C3.

  3. Add a colon (:). You should see that C3 is automatically added again, straight after the colon.

  4. Close the parenthesis, but don't hit <enter> just yet.

  5. Instead, return to the first occurrence of C3 in your calculation and press your F4 key to add dollar signs ($) to both the C and the 3.

  6. Your calculation should look like this: =SUM($C$3:C3)

  7. Hit <enter> to accept the calculation. The result displayed should be 967.

  8. To complete the table, simply double click on the fill handle (the small green square found at the bottom right-hand side of the active cell.

  9. Your table should look like the image seen here.

 

Wondering how you can use a running total in your spreadsheets? Here are some ideas!

  • Keeping a record of sales to date

  • Keeping score in sports or a quiz

  • Keeping an eye on your progress against a target or KPI (key performance indicator)

  • Keeping track of employee performance

  • Working out year-to-date calculations

  • Tracking stock levels

  • Review assets and liabilities at any one point in time on balance sheets

  • Itemised statements for clients

  • Managing mileage claims

  • Recording calorie intake in fitness professions

  • and so much more!

Comment below to let me know how you are going to use running totals in your Microsoft Excel spreadsheets!



Comments


bottom of page