Share via

SUM Function no more working properly

Anonymous
2020-08-21T15:36:27+00:00

Hi, i've been using the SUM(ABOVE) function on my Word documents with no problem since today. But now everytime i update the function i get 0 as result or numbers that means nothing with it. As you can see here, 160,00€ should be the right solution (including ,00€ at the end), but now i get 0.

I never had problems with digits after comma or euro symbol but now this happens in every word document.

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-08-22T03:03:38+00:00

    I see. May I know the Number Format you are using for the formula of "Sum(Above)" ?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2020-08-23T04:32:10+00:00

    Lets see if another user has anymore ideas. Since on my MS Office 2019, I don't any issue if the regional settings was set right.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-08-22T14:21:32+00:00

    I've always left the "Number Format" box empty with no type selection. Now i tried to change it with every available option but nothing changed, the result was the same (0).

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-08-22T01:34:35+00:00

    Hi rianvillareal, thank you for joining this topic. I've just checked my Region & Language settings and they are set on Italy, so it shouldn't be a problem for euro currency. Also Word's language is set to "Italian".

    I tried to create new documents with new tabs and i noticed that if i remove € symbol the function SUM works correctly. But as i said before, 2 days ago i didn't have this kind of problem and i'm sure i haven't changed any settings since then.

    I spoke with Microsoft Support this afternoon and they told me to do an "Online restore" of my Office Pack but this was not successful. Still looking for a solution.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2020-08-21T16:24:40+00:00

    Hi Antonio, hope you're doing well. I’m Ian, an Independent Advisor and Microsoft user like you. I’m happy to help answer your questions.

    I'm sorry to hear about this issue.

    In Word, the table cell will be considered as number or money if the input value is number also comma and period are included. Currency symbol will be accepted, depending on the Country or Region you specified in your "Region and language" settings.

    In your case since you are computing with Euro (€) symbol , the setting should be the Country or Region that using this currency. Example is France.

    Was this answer helpful?

    0 comments