add the 6 least numbers in a list

[kwamena banson]

I have a list of ten numbers and I want excel to add the 6 least
numbers. which formula should I use?
Eg if I have ; 9, 3, 8, 2, 7, 2, 5, 1, 4, 6. the numbers to be added
will be (1+2+2+3+4+5)= 17

thanks.

 

[Bob Phillips]

Try

=SUMPRODUCT(--(SMALL(A1:A10,ROW(INDIRECT("1:6")))))

 

[L. Howard Kittle]

Try =SUM(SMALL(F1:F10,{1,2,3,4,5,6}))

HTH
Regards,
Howard