Lowest two values

[Muz]

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

 

[Pete_UK]

Try this:

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

Fill in your range of cells.

Hope this helps.

Pete

 

[Infinitogool]

Hi Muz

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

Regards,
Pedro J.

 

[RagDyer]

Check answers to your post in the misc. group.

Please don't multi-post!

 

[Bob Phillips]

Don't need SP< SUM is sufficient

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