selecting the two lowest numbers

[Muz]

Hi

I am trying to place the two lowest numbers from a selection into a formula
eg:

selection = 1,3,5,6

Then my formula would be : say 1+3

any ideas???

 

[Fred Smith]

The Small function finds the lowest nth item in a range, as in:

=small(a1:a5,1)+small(a1:a5,2)

Regards,
Fred.

 

[RagDyer]

If your values were entered in A1 to D1, then:

=SUM(SMALL(A11,{1,2}))

 

[Pete_UK]

You have an answer elsewhere - please do not multi-post.

Pete