Sumif for lowerst value within limited to 2 numbers only

K

ken

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.
 
D

Domenic

Sum two lowest values...

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

Sum three lowest values...

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

Hope this helps!
 
Top