Apple numbers formula

When I use sum, the cell shows a value “0” or blank instead of values

Posted on Oct 5, 2022 08:34 AM

Top-ranking reply

jaxjason

Level 5

5,063 points

Posted on Oct 5, 2022 01:08 PM

Check the format of your numbers you are trying to sum. If the column is formatted as text it won’t sum. It has to be some numeric format for sum to work.

jason

View in context

Similar questions

numbers formulas end total on row to be blank if one of the formula cells is temp. left blank Tom
912 12
Can't do sums Hi everyone, I've been looking for a solution already weeks ago without any results. I tried to change the Cell format to currency, number, etc: it doesn't work. It doesn't even seem to affect anything. I always get 0 in the sum. Why is that? And also, why are my number on the left and not on the right of their columns like everyone else?! Thank you so much for your help
772 9
Numbers not adding up Can you Help Please Hi, Using what if formula, to arrive at values in their respective column Then want to simply add up, using Sum, the range of cells in the column Got it to work on some columns, but not others Very strange- have you come across this 2 screen shots- On the cell with the If calc, the other showing the sum calc Thanks in advance if you think you can help
423 4

1 reply

Top-ranking reply

jaxjason

Level 5

5,063 points

Oct 5, 2022 01:08 PM in response to atamton

Check the format of your numbers you are trying to sum. If the column is formatted as text it won’t sum. It has to be some numeric format for sum to work.

jason

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Apple numbers formula

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up