Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

atamton Author

Level 1

8 points

Apple numbers formula

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

Posted on Oct 5, 2022 8:34 AM

Best reply

jaxjason

Level 5

5,047 points

Posted on Oct 5, 2022 1: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

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
244 9
numbers formulas end total on row to be blank if one of the formula cells is temp. left blank Tom
293 12
Numbers 10.1 I entered a SUM formula per instructions and the formula appears but the answer is always zero.
223 3

1 reply

Best reply

jaxjason

Level 5

5,047 points

Oct 5, 2022 1: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

Apple numbers formula

Welcome to Apple Support Community

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

Learn more Sign up