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

[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.

 

[Per Jessen]

Hi

You can use this:

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

Regards,
Per

 

[T. Valko]

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.