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.
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.
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.