Sumif for lowerst value within limited to 2 numbers only
 

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.

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

These formulas are very much helpfull indeed!
Thank you very much.

"Domenic" wrote in message
...

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