Help, how to find a range of data?

[jub366]

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

 

[Barb Reinhardt]

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)

 

[Gary''s Student]

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)

 

[RagDyer]

Try this:

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

--
HTH,

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