# Calc: SUM() function getting wrong results

Hello,

I have a spreadsheet document that is quite important, with numbers and sums. The number in each cell is entered as a manual sum of other numbers (`=11+22+33`

, for instance), and the sums are bold numbers that should regroup some of the original numbers with the `SUM()`

function.

**Here's the number in J24: http://i.imgur.com/ffOeecr.png
Here's the sum, obviously wrong, of C13:C24: http://i.imgur.com/faAFmzf.png**

The other bold number, wrong too, is meant to be a sum of `C4:C12`

.

What do you think is wrong? How can that happen?

Thank you a lot for your help,

~ Nicolas

1876 is the

correct resultto the formula`=756+210+910`

?The result in J24 is the result obtained for C24 first?

Default alignment is left for text and right for numbers.

Thus the suspicion by @floris v that the

otherresults in the range C12:C24 might be of type text.Formulae can well produce results looking like numbers but actually being texts. In addition 'Numbers' formats can lie about the true value... Nobody can find out the truth about this by looking at a screenshot.