How do I average a row of 13 enries using the 8 highest in value.

  • Thread starter Thread starter jacqhty
  • Start date Start date
J

jacqhty

Entries in cells
E3 - 27
F3 - 35
G3 - 82
H3 - 15
I3 - 100
J3 - 86
K3 - 50
L3 - 51
M3 - 65
N3 - 19
O3 - 90
P3 - 12
Q3 - 85
I am using Excel 2003. I have a spreadsheet with many rows of information.
For each row I need to take the eight highest entries and find the average.
 
Try this...

=AVERAGE(LARGE(E3:Q3,{1,2,3,4,5,6,7,8}))

Note that if there aren't at least 8 numbers in the range you'll get an
error.
 
Back
Top