Forum Discussion
SUM function returns wrong result
See below: SUM in column A, from imported values, is WRONG SUM in column B, from same values entered manually is RIGHT Checked that all cells have the same Number format Column C is (A - B) wi...
Hi, thanks but I checked that all values are numbers. Also these values are used by the balance column (E) and seen as numbers that return the correct final balance. Also my original spreadsheet is bigger, where the wrong SUM in column A is not zero but still wrong. NB: Is it possible to join my Excel file to this discussion (I'm a first timer)?
As a comment, in column E you have correct result since you don't use SUM() here. Text which represent numbers are converted to numbers in arithmetic operations and ignored in SUM()
- Thanks all. Interesting point Serguei. I didn't knew that. I saw that the values where in text format and I have set all as numbers. Even so, some of them are still seen as text by the SUM function. It can be seen in the complete spreadsheet. I will share it later.