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
|