I have an Excel spreadsheet that isn't adding up my numbers correctly. Any advice.

Question

question

James-6917 asked Apr 22, '22 CeasarChenMSFT-3458 answered Apr 25, '22

I have an Excel spreadsheet that isn't adding up my numbers correctly. Any advice.

office-excel-itpro

· 2

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Viorel-1 · Apr 22 at 08:53 PM

I suggest asking a question and posting details to understand and reproduce the problem, and the desired results.

0 ·

CeasarChenMSFT-3458 · Apr 25 at 05:47 AM

Hi, @James-6917
I'm working on it and will reply when there is progress.

0 ·

Answer 1 · 2022-04-25T07:17:44.297Z

CeasarChenMSFT-3458 answered Apr 25, '22

Hi, @James-6917
Welcome to the Q&A forum, whether there is an error in your cell addition result, for example: #VALUE!
1. You can refer to the content in this link to check whether the operation or formula is wrong: %E5%B0%86%E6%95%B0%E5%+AD%97%E7%9B%B8%E5%8A%A0%E5%92%8C%E7%9B%B8%E5%87%8F-c3f02baa-5142-40d6-86e3-70ac0a8de9be
2. You can check if the numbers you want to add are in number format:
Right-click the cell and click Format Cells

Check if the cell format is number, if not, change to number format

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

image.png (47.2 KiB)

image.png (29.1 KiB)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question