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
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
If you parse the data into
A1=1.1
B1=1.2
C1=1.3
D1=2.1
E1=2.2
F1=2.3
=SMALL(A1:F1,1)+SMALL(A1:F1,2)+SMALL(A1:F1,3)
"jub366" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
Strangely enough there is a worksheet function called SMALL(). Let’s 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
>
>
Try this:
=SUM(SMALL(A:A,{1,2,3}))
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"jub366" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks