View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JAIrvin JAIrvin is offline
external usenet poster
 
Posts: 1
Default Trying to subtract the two lowest values from a row of numbers

I'm trying to come up with a formula that will let me add all but the lowest
two values in a series (row) of numbers. I can add all but the lowest by
using the MIN function to find the lowest value (and then subtract it from
the sum of all the values), but I can't figure out how to find the second
lowest value.

Any help would be appreciated.