Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to Create Thermometer Chart in Excel
  • How to Create Gantt Chart in Excel
  • How To Create Frequency Distribution in Excel
  • Conditional Formatting Rules in Excel
  • Get column name from index in Excel Table

References

  • How to use Excel LOOKUP Function
  • Find closest match in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • Convert text string to valid reference in Excel using Indirect function
  • How to get address of first cell in range in Excel

Data Validations

  • Excel Data validation don’t exceed total
  • Data validation must not exist in list
  • Excel Data validation must not contain
  • Excel Data validation date in specific year
  • Excel Data validation must contain specific text

Calculate running total in Excel

by

This tutorial shows how to Calculate running total in Excel using the example below;

Formula

=SUM($A$1:A1)

Explanation

To calculate a running total, you can use the SUM formula with a mixed reference that creates an expanding range. In the example shown, the formula in cell D6 is:

=SUM($C$6:C6)

When this formula is copied down the column, it correctly reports a running total on each row.

Worked Example:   Sum range with INDEX in Excel

How this formula works

This formula uses what is called a “mixed reference” to create an “expanding range”. A mixed reference is a reference that includes both absolute and relative parts.

In this case, the SUM formula refers to the range C6:C6. However, the first reference to C6 (on the left of the colon) is absolute and is entered $C$6. This “locks” the reference so that it won’t change when copied.

Worked Example:   Example of Count with Or Criteria in Excel

On the right of the colon, the reference is relative, and appears as C6. This reference will change as the the formula is copied down the column.

Worked Example:   How to create running total in an Excel Table

The result is a range that expands by one row each time it is copied down:

=SUM($C$6:C6) // formula in D6
=SUM($C$6:C7) // formula in D7
=SUM($C$6:C8) // formula in D8

Post navigation

Previous Post:

44 Practical Excel IF function Examples

Next Post:

Large with criteria in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Extract multiple matches into separate rows in Excel
  • IF, AND, OR and NOT Functions Examples in Excel
  • IF with boolean logic in Excel
  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • FALSE function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Get project midpoint in Excel
  • Get last day of month in Excel
  • Get day from date in Excel
  • Convert Excel time to decimal hours in Excel
  • DAY function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • Group times into unequal buckets in Excel
  • How to randomly assign data to groups in Excel
  • Group times into 3 hour buckets in Excel
  • Categorize text with keywords in Excel
  • Group numbers at uneven intervals in Excel

General

  • Excel Operators
  • Split Cell Content Using Text to Columns in Excel
  • How to calculate percent sold in Excel
  • How to choose page/paper size in Excel before Printing
  • How to calculate total from percentage in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning