Sum two lowest values...

=SUM(SMALL(A1:F1,{1,2}))

Sum three lowest values...

=SUM(SMALL(A1:F1,{1,2,3}))

Hope this helps!

ken Wrote:
A B C D E F G

3 1 2 2 3 4 =i need formula here

What the formula to sum only two numbers that have the lowest value of
all
( 1 and 2 ). If I three numbers requires for the sum, it should be (1
, 2
and 2 ).

Please help.


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=277305