@slothrop
Assumption: your numbers are not numeric values but just text that looks like numbers, and text is ignored in SUM(). Standard behaviour in all major spreadsheet applications.
To check hit Ctrl+F8 (View -> Value Highlighting) then text content is displayed black, numeric content blue and formula results green.