View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Infinitogool Infinitogool is offline
external usenet poster
 
Posts: 52
Default 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