Calculate running total in Excel and Google Sheets

=SUM($A$2:A3)

$A$2 = fixed cell; A3 = moving/dynamic cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Calculate running total in Excel

How to calculate the running total in Excel?
CALCULATE RUNNING TOTAL — EXCEL FORMULA

CALCULATE RUNNING TOTAL — EXCEL FORMULA AND EXAMPLE

=SUM($A$2:A3)

  • $A$2 = fixed cell

  • A3 = moving/dynamic cell

This formula will calculate the running total where $A$2 is a fixed cell (keyboard shortcut = F4), and the next row will dynamically move as you drop down the formula.

Calculate running total in Google Sheets

How to calculate the running total in Google Sheets?
Calculate running total in Google Sheets

CALCULATE RUNNING TOTAL — GOOGLE SHEETS FORMULA AND EXAMPLE

=SUM($A$2:A3)

  • $A$2 = fixed cell

  • A3 = moving/dynamic cell

This formula will calculate the running total where $A$2 is a fixed cell (keyboard shortcut = F4), and the next row will dynamically move as you drop down the formula.

Other widely used Excel and Google Sheets formulas explained
Others Useful FormulasDate and time functionsNumber based criteriaText-based criteriaExtract functions