When you sum a column of numbers using SUM, it returns 0. The contents of the cells look like numbers. Only the total is incorrect. This often happens with CSVs exported from internal systems, tables ...