An eqation to add the largest 6 (or N) numbers from a list
Try this:
=IF(COUNT(A1:A10)=0,0,IF(COUNT(A1:A10)<=6,AVERAGE( A1:A10),AVERAGE(LARGE(A1:A10,{1,2,3,4,5,6}))))
If there are more than 6 numbers, averages the top 6 numbers.
If there is <=6 numbers, averages what's there.
--
Biff
Microsoft Excel MVP
"cellofellow" wrote in message
...
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!
|