Build a cumulative running total down a column with a mixed reference.
Copy this formula
=SUM($B$2:B2)Lock the start of the range with an absolute reference ($B$2) and leave the end relative (B2). As you fill down, the range grows — B2:B2, then B2:B3, then B2:B4 — producing a running total.
=SUM($B$2:B5)→1,180Cumulative total of rows 2 through 5.
=SUM($B$2:B2)/SUM($B$2:$B$13)→8%Running total as a share of the full-year total.
=C2+B3→450A simpler version: add the current row to the running total in the cell above.
Spill (Excel 365)
=SCAN(0, B2:B100, LAMBDA(a,b, a+b))Returns the whole running-total column in one formula.
Relative references shift on sort. Use the SCAN spill version, or convert the range to a Table for stable structured references.
Use SUMIF with an expanding range: =SUMIF($A$2:A2, A2, $B$2:B2) totals only the rows of the same group so far.
$B$2 locks the start of the range while B2 moves as you fill down, so the range grows by one row each time.
Right-click a value, choose Show Values As ▸ Running Total In, and pick the date or category field.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.