Jobs & Education1 min ago
Excel Sum Function not working
7 Answers
I have an inherited Excel spreadsheet and the sum function has stopped working in one particular area. If I do the sum [ =SUM(AF6:AF255) ] then it returns the correct answer, however if I add a figue in cell AF7 for example, the sum figure at the top does not change.
I am getting a small green corner error indicator on the cell; this states that the cell is not locked and contains a formula so it may want to be protected to avoid any c hnages inadvertently...
Interestignly, if I copy and paste special a blank cell from another workbook, it will not allow me to as it is treating the area I want to paste to as an object?
I am getting a small green corner error indicator on the cell; this states that the cell is not locked and contains a formula so it may want to be protected to avoid any c hnages inadvertently...
Interestignly, if I copy and paste special a blank cell from another workbook, it will not allow me to as it is treating the area I want to paste to as an object?
Answers
Best Answer
No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.Is the sheet set to either manual recalculation or automatic except tables in the option? (if you're using column AF I can see why it might be set to manual as it's obviously a large sheet)
You can force a recalculate with CTRL + ALT + F9 or see if it is set to manual calculate and set it to automatic (although this may slow things down if it's a really large sheep)
You can force a recalculate with CTRL + ALT + F9 or see if it is set to manual calculate and set it to automatic (although this may slow things down if it's a really large sheep)
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.