This spreadsheet is used to track each team's balance ($) during a Fantasy Football draft for work.
Cell A20 = $120 ---> [Each teams starts the draft with $120]
Cell C20 = (A20-sum(E5:E19)) ---> [Calculates a team's current balance throughout the draft as they spend money (amount entered in cells E5:E19)]
The formula works, but the value does not display correctly after each change.
That is, after a value is added to any of the cells from E5:E19, the "Current Balance" cell C20 no longer displays correctly.
If I scroll down until cell C20 is no longer visible, and then scroll back up, the issue resolves itself somehow, but this has to be done every single time a value is entered into any of the cells E5:E19.
This image may explain this issue better than I have so far:
http://i.imgur.com/rrZbg.png
Bookmarks