SUM function not working correctly (not a rounding issue)

I cannot confirm your problem.

When I add: "34000+7000+7000+30500+7000+3000+1500" in the spotlight (top right of the menu bar), the total of is 90,000

Using Numbers, I also get 90,000

=SUM(E1:E8)

There is something wrong with your data.

Please post a screenshot

I suspect a simple error of some sort on your part. Your numbers add up to 90,000, not 91,000. Your expression: "SUM E4:E11" is not a proper Numbers expression format. If you show us a screen shot with the sum formula cell selected and the bar at the bottom of the screen showing, we may be able to help.

Jerry

I suspect one of your cells is formatted as text. While text cells will add up using the "+" operator, they do not sum using the SUM function. The very first number on your list is not aligned with the rest and it is the exact amount you are off so I suspect it is the culprit.

Had you posted a screenshout we all would have seen that one of the cells was justified as text and NOT a number:

Wayne Contello wrote:

Had you posted a screenshout we all would have seen that one of the cells was justified as text and NOT a number:

Except that someone might see that misaligned number in their table and right justify it so it looks like the rest of them but will neglect to mention this (because they don't know it is important)