A reservation total stays at 10 even after an input changes. Select the total cell and verify that it still contains the formula you expect.
Check Manual and run Calculate Now
In a test copy, put 6 and 4 in B2:B3 and =SUM(B2:B3) in B4. Change B2 to 8. If B4 stays at 10, check Formulas → Calculation Options in Ulet. Use Calculate Now and expect 12.

Illustrated stale result. Inspect the actual formula before diagnosing the mode.
Verify automatic updates with one more edit
Select Automatic if formulas should recalculate as you type. Change 8 to 9 and expect 13. Confirm any summary on another tab agrees. If the result still differs, check the source values and referenced range before saving.

Illustrated control check. Verify a dependent summary too.



