Forum Discussion
Excel Sum function
Fullname: Mei Cheung Contact email: Email address removed Contact numbers: 07872160641 Reference chat case: 1034231325 Issue: I cannot use SUM() function properly. I have copy & pasted sums from...
Thank you for all you gentlemen's replies! Sorry, I find it hard to follow instructions to try them out! I hve just managed to find BROWSE and attach this file! I appreciate all yr help!
I hope u can open this 97-2003 Exel sheet. I had been using the version for last 10 years nicely until a friend subscribed me onto Office 365 when I starting getting troubles! Now I can't open older versions of 97-2003, someone taught me I had go thru 7 steps in order to open it up in 365!😓
Ruth Reah is the Customer Services Assistant who tried to help & guided me to post my Question on Forum. I have copied our chat below, she says perhaps you guys can "Roll out some excel code to fix the formatting issue?" This would be great if you can do this! A simple method which I don't need to figure things out myself!!🙏😂 thanks!!
------------------------------------------------------
January 19, 2022, 7:41 pm
mei
Hello Mei! Based on the investigation we just did on the excel file that you have right now. It appears that the problem is the specific file that you are working right now. I am afraid that there's need for you to manually recreate this file especially the numbers because when I tried to manually change it auto sum worked though.
-------------------------------------------
January 19, 2022, 7:52 pm
Ruth Reah
What I can advise mei is that, you can post this concern of yours to the excel mvp and editor's page. You can request for assistance in recreating this file or they can probably roll out some excel code to fix the formatting issue. In this way you don’t have to effortly recreate the file what you just need to do is wait until an editor is ready to provide resolution to it. What do you think about this Mei?
I hope u can open this 97-2003 Exel sheet. I had been using the version for last 10 years nicely until a friend subscribed me onto Office 365 when I starting getting troubles! Now I can't open older versions of 97-2003, someone taught me I had go thru 7 steps in order to open it up in 365!😓
Ruth Reah is the Customer Services Assistant who tried to help & guided me to post my Question on Forum. I have copied our chat below, she says perhaps you guys can "Roll out some excel code to fix the formatting issue?" This would be great if you can do this! A simple method which I don't need to figure things out myself!!🙏😂 thanks!!
------------------------------------------------------
January 19, 2022, 7:41 pm
mei
Hello Mei! Based on the investigation we just did on the excel file that you have right now. It appears that the problem is the specific file that you are working right now. I am afraid that there's need for you to manually recreate this file especially the numbers because when I tried to manually change it auto sum worked though.
-------------------------------------------
January 19, 2022, 7:52 pm
Ruth Reah
What I can advise mei is that, you can post this concern of yours to the excel mvp and editor's page. You can request for assistance in recreating this file or they can probably roll out some excel code to fix the formatting issue. In this way you don’t have to effortly recreate the file what you just need to do is wait until an editor is ready to provide resolution to it. What do you think about this Mei?
meicheung Can't really tell why this problem occurred after upgrading to MS365. Had a brief look at the file and noted two things. The "numbers" in column H contain leading spaces and the negative numbers have a CR prefix. You need to get rid of these so that they become real numbers with which you can calculate. Have used Find&Replace (ctrl-H) to do just that.
The end result is in column K.
