Help, how to find a range of data?
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 |
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" 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 |
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 |
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 |
All times are GMT +1. The time now is 09:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com