View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cellofellow cellofellow is offline
external usenet poster
 
Posts: 2
Default An eqation to add the largest 6 (or N) numbers from a list

I am trying to get an average of list, but if there are more than 6 numbers
in the list to only use the top 6 values. My first thought was some sort of
sum of top six then a count of numbers from the list (in case there are not 6
numbers in the list).
Any help is appreciated!