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

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.

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

Hi

You can use this:

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

Regards,
Per

On 12 Jan., 02:28, jacqhty wrote:
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.

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

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.

--
Biff
Microsoft Excel MVP


"jacqhty" wrote in message
...
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.