How to do a running total in Excel (Cumulative Sum formula)
Apr 21, 2025 am 11:16 AMThis concise guide demonstrates how to efficiently calculate running totals (cumulative sums) in Excel using a SUM formula with strategically placed absolute and relative cell references. A running total displays the accumulated sum of a dataset as it grows, updating with each new addition. This is useful for tracking scores, sales, bank balances, and more.
Calculating Running Totals in Excel
To calculate a running total for values in column B, starting from B2, enter this formula in C2 and copy it down:
=SUM($B$2:B2)
The $B$2
portion (absolute reference) remains constant, always referencing cell B2. The B2
(relative reference) adjusts as the formula is copied, expanding the summation range. Thus, in C3, the formula becomes =SUM($B$2:B3)
, and so on.
This method also works for tracking bank balances (positive for deposits, negative for withdrawals). Enter values in column C, and use this formula in column D:
=SUM($C$2:C2)
Handling Blank Cells
To prevent displaying the last calculated total in rows below the last data entry, use this improved formula:
=IF(C2="","",SUM($C$2:C2))
This checks if C2 is empty; if so, it returns a blank cell; otherwise, it calculates the running total.
Creating a Cumulative Chart
Once the running total is calculated:
- Select your data (including the running total column).
- Insert a 2-D clustered column chart (via the Insert tab).
- Select the running total data series.
- Right-click and choose "Change Series Chart Type...".
- Select "Combo" chart type and choose a line chart for the running total series (e.g., "Line with Markers").
- Click "OK". Add data labels (optional) by right-clicking the line and selecting "Add Data Labels".
Customize chart titles, legends, and styles as needed. This creates a visual representation of your cumulative data.
The above is the detailed content of How to do a running total in Excel (Cumulative Sum formula). For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

Quick Links Parentheses: Controlling the Order of Opera

This guide will walk you through how to customize, move, hide, and show the Quick Access Toolbar, helping you shape your Outlook workspace to fit your daily routine and preferences. The Quick Access Toolbar in Microsoft Outlook is a usefu

Ever played the "just one quick copy-paste" game with Google Sheets... and lost an hour of your life? What starts as a simple data transfer quickly snowballs into a nightmare when working with dynamic information. Those "quick fixes&qu

Quick Links Copy, Move, and Link Cell Elements

Quick LinksRecalculating Formulas in Manual Calculation ModeDebugging Complex FormulasMinimizing the Excel WindowMicrosoft Excel has so many keyboard shortcuts that it can sometimes be difficult to remember the most useful. One of the most overlooked

Whether you've recently taken a Microsoft Excel course or you want to verify that your knowledge of the program is current, try out the How-To Geek Advanced Excel Test and find out how well you do!This is the third in a three-part series. The first i

1. Check the automatic recovery folder, open "Recover Unsaved Documents" in Word or enter the C:\Users\Users\Username\AppData\Roaming\Microsoft\Word path to find the .asd ending file; 2. Find temporary files or use OneDrive historical version, enter ~$ file name.docx in the original directory to see if it exists or log in to OneDrive to view the version history; 3. Use Windows' "Previous Versions" function or third-party tools such as Recuva and EaseUS to scan and restore and completely delete files. The above methods can improve the recovery success rate, but you need to operate as soon as possible and avoid writing new data. Automatic saving, regular saving or cloud use should be enabled

Quick Links Let Copilot Determine Which Table to Manipu
