View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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