This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
(1)Have a formula in a file that is not calculating properly. The “SUM” formula is supposed to add the values that are input into any of the cells in the column range that the formula covers. For example, the formula is setup as +sum(F980:F1033) which if working properly would calculate the total of all values that are input in any of the cells in Column F from F980 through F1033. It is not updating a column total as values are input into any of these cells.
(2) The second problem I have encountered occurs when trying to copy a cell formula from one cell to another cell. When attempting to do so the copy function is displaying the calculated value from the cell the formula was being copied from into the cell the formula is copied into. For example, on a spreadsheet if I try to copy the formula that was in the "2017 Total" cell of say our our electric service charges into the cell setup for "2018 Total" electric charges the copy function is displaying the dollar value of the total 2017 charges when it should be displaying $0.00 until some 2018 charges are input.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Go to Formulas tab > on right side, you have Calculation Options which you change to Automatic.
This should resolve both your problems.
Thank you for your help!!! It did solve both problems. Have a nice day.