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
|