Find lowest 5 values in a list of 10 - 150 lists involved

[Guest]

I am trying to find an easy way to determine the lowest 5 values in a list of 10 and add those values together. There are 150 lists involved in which the determination is to be made. I will then compare the sums of the 150 lists and determine the lowest 10 sums. What is the easiest way to do this using Excel?

 

[JE McGimpsey]

one way:

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

 

[Frank Kabel]

Hi
use SMALL
for this

if you want to sum the smalles 5 values try the formula
=SUM(SMALL(A1:A100,{1,2,3,4,5}))

 

[Soo Cheon Jheong]

Hi,

Try the following formula(array formula) for non-zero values:

=SUM(SMALL(IF(A1:A150<>0,A1:A150,""),{1,2,3,4,5}))

--
Regards,
Soo Cheon Jheong
_ _
^¢¯^
--

I am trying to find an easy way to determine the lowest 5 values in a list

of 10 and add those values together. There are 150 lists involved in which
the determination is to be made. I will then compare the sums of the 150
lists and determine the lowest 10 sums. What is the easiest way to do this
using Excel?