Hi Bevin B.

Try this;

=SUM(SMALL(A1:A18,{1,2,3,4,5}))

Of course change the range to suit.

HTH
Regards,
Howard


"bevinb" wrote in message
...
Hi, I have a long list of numbers in a column. I want to find the 5
together that have the lowest sum but do not want to sort them. i.e.,
the lowest total of the five as they are arranged on the spreadsheet
now. I thought I had done this previously and it wasn't that
difficult but now I cannot for the life of me remember how or even if
I did accomplish it! Any help appreciated.

Excel 2003

Thanks, Bevin B.