Home > Uncategorized > Average of n samllest or n biggest numbers from a list

Average of n samllest or n biggest numbers from a list

February 22nd, 2006 Leave a comment Go to comments

To calculate the average of n biggest numbers from a list enter this formula with Ctrl + Shift + Enter:

=AVERAGE(IF(RANK(yourrange,yourrange)<=n,yourrange,”"))

To calculate the average of n smallest numbers from a list enter this formula with Ctrl + Shift + Enter:

=AVERAGE(IF(RANK(yourrange,yourrange)>COUNT(yourrange)-n,yourrange,”"))

For an example:

Share
[CiteULike] [del.icio.us] [Digg] [Facebook] [Furl] [Google] [Reddit] [Slashdot] [StumbleUpon] [Technorati] [Twitter] [Email] More »
Powered by Bookmarkify™
Categories: Uncategorized Tags:
  1. No comments yet.
  1. No trackbacks yet.