Forum Discussion
Solved
Problem with a SUM function not working properly
Something bizarre has happened with my Excel files. As an example, I have a cell that performs the operation =SUM(F4 + F5). The data put into that cell is correct for the defined operation. For pu...
Hi Kenneth,
Are your Calculation Options set on Automatic?
Hi Kenneth,
Are your Calculation Options set on Automatic?
- They are now! Thank you. Everything works properly again. For some reason the latest updates that the computer went through changed all sorts of setting in several programs including Excel. I never thought to check that setting. It had reverted back to manual and I was not aware of it.
Just as an FYI - you don't need the SUM() function here. SUM() is to add a range of data. You just need =F4+F5, or =SUM(F4:F5).
The SUM function above will expand to F4:F6 if you were to insert a row. But if you are just adding specific cells, just write =F4+F5+F9+J10 or whatever you need.
- Thank you for your suggestion. I appreciate the input.
