Try this:

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

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"jub366" wrote in
message ...

If i have a numbers in the cell . eg : 1.1 , 1.2 , 1.3 , 2.1 , 2.2 , 2.3


for this numbers i want to find say like 3 smallest number then Sum it
up.

it will be equal to 1.1 + 1.2 + 1.3 = 3.6

question is what function should i be using ?


thanks


--
jub366
------------------------------------------------------------------------
jub366's Profile:
http://www.excelforum.com/member.php...o&userid=27985
View this thread: http://www.excelforum.com/showthread...hreadid=474925