Contractor Talk - Professional Construction and Remodeling Forum banner

Excel =SUM question.

4030 Views 28 Replies 9 Participants Last post by  Work2Painting
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.


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?
1 - 2 of 29 Posts
Only if you insert columns or lines...
That's not true.

If you make the formula =SUM($B$2:$B$20) and insert a column between A and B, the formula changes to =SUM($C$2:$C$20) ...where column C was originally column B.

If you make the formula =SUM($B$2:$B$20) and insert a row between 1 and 2, the formula changes to =SUM($B$3:$B$21) ...where row 3 was originally row 2.

Relative cell references only change if you drag the formula around.

Now, all that said....I thought what you said was true. I guess it's never come up before (hard to believe with the amount of excelling I do, but **shrug**). So I checked, and tested what I just typed out.

One more caveat :) ...I don't know if this is an application level option that you could change to "Not update cell references on row/column insert or delete", or if "that's just the way it's not an option". I didn't look through the options.
I don't know anything about could be because SUM is an excel maybe Kingsoft isn't recognizing that...??

I guess if it remains a problem, you could change the formula to:


If you have to do it too many places, I would type that out in Word or something, and then C/P it into whatever cells you need it in.

I still can't imagine why making the references absolute ($) would make a difference. You would think if Kingsoft recognizes that, it would recognize a relative reference as well.

EDIT: Didn't take as long as you would think LOL. (It's a slow day, what can I say). Doing in excel was faster BTW.....+(click)+(click)+(click)+(click)+(click)+(click)+(click)+(click)

Anyhow, if you're interested...


You have a few fixes to do...some of the numbers "came apart" when copying from there to here.
1 - 2 of 29 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.