View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
whymj whymj is offline
external usenet poster
 
Posts: 4
Default Formula Help Please

I need help setting up a formula to look at a range of data (will vary
between 4, 5, or 6 values), choose the 4 highest values and add them together
(ignoring the rest).

ie.
b1 = 25
b2 = 18
b3 = 21
b4 = 23
b5 = 22
b6 = 25
Total = 95 (ignoring 18 & 21)

or:
b1 = 25
b2 = 18
b3 = 21
b4 = 23
b5 = 22
Total = 91 (ignoring 18)

Thanks!