Skip to content

Running total

A cumulative sum that grows row by row.

The formula

Argument separator
Excel and Google Sheets
=SUM($B$2:B2)

How it works

  1. $B$2

    The start of the range stays fixed.

  2. B2

    The end moves down as you fill the formula, so each row sums everything above it.

Example

A: MonthB: AmountC: Result
Jan100100
Feb150250
Mar50300

Tips

  • In Excel 365 or Sheets, =SCAN(0, B2:B13, LAMBDA(a, b, a+b)) creates the whole column at once.