OK, here's the short story. I run an Excel spreadsheet to do my quarterlies. I have a copy of this on my Galaxy S4 and use Kingsoft Office to open it and modify it. All has been well up until today or recently because I'm not sure when the issue started.
In my phone my SUM functions weren't recalculating. I would enter a number in the field and the SUM would remain the same.
They were working in my laptop using Excel 2003.
One of the SUM functions is written as =SUM(B5:B102), so it adds up the numbers in the column B, cell 5-102.
After fooling around with it for a while and trying different things I came up with a workaround.
=SUM($B5:$B102)
OK, I have no idea what this change is/does. I only know that it solved my problem.
Anyone know what this version of the SUM function I am using does?
In my phone my SUM functions weren't recalculating. I would enter a number in the field and the SUM would remain the same.
They were working in my laptop using Excel 2003.
One of the SUM functions is written as =SUM(B5:B102), so it adds up the numbers in the column B, cell 5-102.
After fooling around with it for a while and trying different things I came up with a workaround.
=SUM($B5:$B102)
OK, I have no idea what this change is/does. I only know that it solved my problem.
Anyone know what this version of the SUM function I am using does?