View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen53 Karen53 is offline
external usenet poster
 
Posts: 333
Default Calculating value less minimum numbers in the sequence

I am trying to find a function that will add a series of numbers LESS the 2
lowest numbers in the seqeunce. They are not in order from lowest to smallest
as there is more than one group and it is sorted by date.

Example:

172 172 172 180 169 180 163 180 175 165 180 175 180

I would need it to pull out the 163 & 165 and add the rest. These numbers
will be different for each row and the lowest are not always in the same
column. Any ideas??

thanks!

Karen