View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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