Lowest two values
 

Hi
I am trying to write a formula using the two lowest numbers from a selection
where say x=lowest and y=second lowest

=x+y

any suggestions?

ps. x and y may sometimes be the same number

Lowest two values
 

Try this:

=SMALL(range,1)+SMALL(range,2)

Fill in your range of cells.

Hope this helps.

Pete

On Jul 29, 12:43*am, Muz wrote:
Hi
I am trying to write a formula using the two lowest numbers from a selection
where say x=lowest and y=second lowest

=x+y

any suggestions?

ps. x and y may sometimes be the same number

Lowest two values
 

Hi Muz

Try:
=SUMPRODUCT(SMALL(range,{1,2}))

Regards,
Pedro J.

Hi
I am trying to write a formula using the two lowest numbers from a selection
where say x=lowest and y=second lowest

=x+y

any suggestions?

ps. x and y may sometimes be the same number

Lowest two values
 

Check answers to your post in the misc. group.

Please don't multi-post!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Muz" wrote in message
...
Hi
I am trying to write a formula using the two lowest numbers from a
selection
where say x=lowest and y=second lowest

=x+y

any suggestions?

ps. x and y may sometimes be the same number

Lowest two values
 

Don't need SP< SUM is sufficient

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

--
__________________________________
HTH

Bob

"Infinitogool" wrote in message
...
Hi Muz

Try:
=SUMPRODUCT(SMALL(range,{1,2}))

Regards,
Pedro J.

Hi
I am trying to write a formula using the two lowest numbers from a
selection where say x=lowest and y=second lowest

=x+y

any suggestions?

ps. x and y may sometimes be the same number