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.

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.

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



