Share via

Exce

Anonymous
2022-01-18T18:01:00+00:00

New to Excel and creating a table. I have zeros in some columns and when I use the sum function where there is a zero in a column the total at the end is zero. I did not have this issue across the rows. Please advise what am I doing wrong...Thank you.

Microsoft 365 and Office | Excel | For home | MacOS

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

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-01-19T18:21:29+00:00

    So I created what I thought was a table excel 465 with a Mac laptop

    I am not sure what your other questions were referring to. When I use the sum function across the rows this zeros did not seem to present an issue except in the world where of 10 columns that was one Number. However, when I was trying to use the sum function going down the columns nothing seems to work when they were zeros in the columns. So after poking around and reading your comments I went back and Took the zeros out of the table or chart I’m not sure if it makes a difference and then edit up the columns.

    I don’t know if this is right because when I was reading something about hiding the zeros I didn’t know what that meant door even how to do it. Please let me know if when I tried to create pivot tables having taken the zeros out of certain of the boxes it’s going to make a difference. Thank you for your comment

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2022-01-18T18:38:03+00:00

    Hi

    My name is André. I am an independent consultant.

    Can you share a screenshot of this situation to make it a little clearer?

    Answer here so I can continue helping you.

    André.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Bob Jones AKA CyberTaz MVP 435.3K Reputation points
    2022-01-19T04:11:15+00:00

    In addition to the request for a screen shot:

    • Are you applying the Excel Table feature to a range of data or are are you referring to a simple list range as a table?
    • From Excel> About Microsoft Excel what is indicated as the Version & type of License for your Office software?
    • Which specific flavor of macOS are you using?
    • What additional detail can you supply [e.g., Are all sheets affected in the same way? If you enter values in a new workbook do you have the same problem?]

    Was this answer helpful?

    0 comments