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
|