The sign-out log has changes of 8, 5, −2, and 9. Show the net total after each change using an expanding range.

Anchor the first cell and fill down

Put the changes in B2:B5. In C2 enter =SUM($B$2:B2) and fill to C5. The totals should be 8, 13, 11, and 20. C2 and C5 both start at $B$2. The end advances to B5.

The first reference stays at $B$2 while the endpoint moves down.

Illustrated expanding range. Keep the records in the intended order.

Check the negative adjustment and the final total

The −2 adjustment should drop the total from 13 to 11. Check that C5 equals =SUM(B2:B5). If the total describes events in time order, sort the source by date and resolve ties before filling the formula. After adding records, make sure it reaches the new last row.

The running total drops from 13 to 11 at the negative adjustment.

Illustrated reconciliation. The last total equals the sum of all four changes.

Microsoft’s running total example