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

James 1 Reputation point
2022-04-22T20:02:50.377+00:00

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

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,687 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Ceasar Chen_MSFT 4,391 Reputation points
    2022-04-25T07:17:44.297+00:00

    Hi, @James
    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
      195960-image.png
      Check if the cell format is number, if not, change to number format
      196021-image.png

    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.

    0 comments No comments