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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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}))
 
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
_ _
^¢¯^
--




JoeB said:
I am trying to find an easy way to determine the lowest 5 values in a list
Click to expand...
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?
 
Back
Top