I don't have Excel I open the file with oocalc sort it and select part of it then copy/paste to a new file in oocalc
-------------------------------------------- On Fri, 9/18/15, Curt <cu...@free.fr> wrote: Subject: Re: how to sum a column in openoffice calc To: debian-user@lists.debian.org Date: Friday, September 18, 2015, 8:06 AM I know how you feel. Have you tried opening the Excel file directly in Open Office Calc?