selecting the two lowest numbers
 

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???

selecting the two lowest numbers
 

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

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

Regards,
Fred.

"Muz" wrote in message
...
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???

selecting the two lowest numbers
 

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

=SUM(SMALL(A1:D1,{1,2}))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Muz" wrote in message
...
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???

selecting the two lowest numbers
 

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

Pete

On Jul 29, 1:21*am, Muz wrote:
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???