Strangely enough there is a worksheet function called SMALL(). Lets say
your numbers are stored in A1:A100. Then the sum of the three smallest is:
=SMALL(A1:A100,1)+SMALL(A1:A100,2)+SMALL(A1:A100,3 )
--
Gary's Student
"jub366" wrote:
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