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) with results = 0,00 -> number are seen as equals
Balance calculated on the WRONG column A has the RIGHT result
Why is the column A SUM wrong.? What is the difference between the A & B cells
(not value, not format)
Microsoft Excel for Mac, version 16.57 (22011101)
macOS 12.2 on a MacBook Air M1
9 Replies
Michel_Verschueren I suspect that the imported values in column A are in fact texts. That's why SUM returns zero.
- 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()
