View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
stevengepp stevengepp is offline
external usenet poster
 
Posts: 3
Default Adding more than one maximum

Is there a way of taking a list of five numbers and adding together only the
highest 3 (ignoring or dropping the two lowest marks)? E.g. if the numbers
were 2,5,7,4,5, the numbers 5,7,5 would be added, 2 and 4 being ignored.