Sorry, it is a colon. My mistake.
Edited original post to correct
Edited original post to correct
Excel =SUM question.
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?
1 - 13 of 29 Posts
That was a good point. But I don't think my phone app has that function. It has a recacl button but no options other than that.An issue may be that your program is not automatically recalculating. This function can be turned on and off.
So if auto recalc is off, then the sum function will not execute.
Hope this helps.
It seems to be this spreadsheet file only as I have a couple of others that use a very similar format and setup as this one and they work.
If I transferred it from my phone to my laptop which is running Excel 2003 it functions fine. If I transfer it back to my phone it stops recalculating.
So now that I have this absolute function in my formula's (I've changed the whole spreadsheet to use them), is there going to be problems with my formulas?
And another item. I had made a blank of this spreadsheet because I use it to do my quarterlies. And when the next year comes I just change the date and start over.
When I transferred that file to my phone it didn't work either. Changing it to the absolute SUM makes it function properly again.
When I transferred that file to my phone it didn't work either. Changing it to the absolute SUM makes it function properly again.
I guess that's gonna be a problem then, because I do insert on occasion.Only if you insert columns or lines...
Since I'm using the lock column version of it. If I have column B-K used and I make/insert another column "L" then I have nothing to worry about, correct?
And this gives me the option to insert new rows if I want to and it won't screw anything up, correct?
My rows are Date them a dollar figure in the appropriate column. On occasion I miss an entry and then insert the missed date in the correct position and then make the entry. This will still function properly?
And this gives me the option to insert new rows if I want to and it won't screw anything up, correct?
My rows are Date them a dollar figure in the appropriate column. On occasion I miss an entry and then insert the missed date in the correct position and then make the entry. This will still function properly?
I'm operating my file from two different programs. And although the Kingsoft Office is pretty complete the laptop version has more options.
Never knew I could turn recalc on and off.
I really don't understand why the phone app has the recalc button when there is no option to turn it off. I assume it's because you might import a file from a computer that has the recalc turned off and if you go to the phone app you wouldn't be able to use the program.
And I did try to use the recalc button before I swapped my SUM formulas to absolute, it didn't work.
Never knew I could turn recalc on and off.
I really don't understand why the phone app has the recalc button when there is no option to turn it off. I assume it's because you might import a file from a computer that has the recalc turned off and if you go to the phone app you wouldn't be able to use the program.
And I did try to use the recalc button before I swapped my SUM formulas to absolute, it didn't work.
I do it throught wifi. I have ES Explorer which allows me to set my phone up as an FTP and I have a FTP Program (WiseFTP 6.1) that I use mostly for updating my website, but I use it to transfer files to and from my phone.How are you transferring files between your phone and PC? A cable?
Push a couple buttons and then I have direct access to both phone and computer.
It's the year of the NSA and the hacker. I don't plan on putting my companies financial information in the cloud.What year is it there?
1 - 13 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.
Contractor Talk - Professional Construction and Remodeling Forum
A forum community dedicated to professional construction and remodeling contractors. Come join the discussion about the industry, trades, safety, projects, finishing, tools, machinery, styles, scales, reviews, accessories, classifieds, and more!
Full Forum Listing
Explore Our Forums
Recommended Communities
Join now to ask and comment!
