Forum Discussion
Excel Sum function
Hi Joe,
Thanks for yr detailed explanation but so sorry I don't understand what you are saying- I am complete non-tech dumb dumb person! I want to attach the excel file to you but sorry I am not familiar with hotmail's layout ( I hardly use it!) I can't see button wheree to attach it to you? I thoght that Ruth who guided me to you had done it already?!
kind thnsk!
Mei
meicheung wrote: ``I don't understand what you are saying``
Sorry about that. If Sergei's workaround does not work for you, try to follow the directions below to attach an Excel file to a response here.
Do not paste an image of the data. That is completely useless when we suspect that the type and content of the data (text, perhaps containing "invisible" characters) is the problem.
Be sure the Excel file duplicates the problem (SUM returns zero). Be sure to omit any personal identity data (account numbers, full names, etc).
If you do want to publish real balance and transaction numbers, reduce the data to 2 or 3 entries that cause SUM to return zero.
The click "browse" near the bottom of the reply pane, to wit:
When you click "browse", it opens a dialog box that allows you locate and select the file to be attached.
I hope that is clear. If not, I hope that Ruth can help you, whoever she is.
- 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?
FYI: ability to attach file is not for everyone, I have no idea what is the logic behind. Workaround the file could be attached to private message or share on OneDrive or like.
