Quoting Li Wei (root...@yahoo.com): > I don't have Excel > I open the file with oocalc
It was suggested in Carl Fink's posting https://lists.debian.org/debian-user/2015/09/msg00743.html that the numbers that you are trying to sum are not numbers at all. Could you check that out and respond. It would help to do this immediately after you reach this stage, ie after opening the excel file in oocalc ... > sort it and select part of it > then copy/paste to a new file in oocalc ... and check a second time at this stage, ie after pasting into the new spreadsheet. Cheers, David.