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