Forum Discussion
Solved
Formulas
I have been using Excel for many years but just in the last couple of days, something has happened to the Formula function in my spreadsheets. I set the formula to add boxes A1 through to say A20 in ...
Hi,
You probably have the calculation option in the manual state!
Please make sure the calculation option is set to Automatic as follows:
Hope that helps
It seems that sum formula in column A is freeze =SUM($A$1:$A$20).
You just need to remove $ sign (=SUM(A1:A20)) from that formula and then drag it to B22 or C22.
Alternatively you may share your file so issue can be directly fixed in the file.
Thanks