Jun 08 2018
07:10 AM
- last edited on
Jul 31 2018
08:24 AM
by
TechCommunityAP
Jun 08 2018
07:10 AM
- last edited on
Jul 31 2018
08:24 AM
by
TechCommunityAP
When I add up formula results using auto sum on my computer no problem to get total.
A co worker sent me a file, I try to add up formula results and I get 0. If I change values to static it adds up fine. If I create a sum formula in another column and then drag over it works fine.
Is this a setting issue as to why it wont add up these formula results. Never seen anything like this.
Jun 08 2018 07:27 AM
Hi Steve,
It seems that the numbers you got from your co-worker are treated as texts not as numerical numbers.
However, one of the fastest ways to parse them and convert them to the numeric status is:
After that, try to auto sum these numbers, and tell me what you think!
Jun 08 2018 07:49 AM
Jun 08 2018 07:51 AM
May 09 2019 10:16 AM
I have same problem since I upgraded office360.
how do I take a circular reference out? @Steve Carey