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.

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 <jacq...@discussions.microsoft.com> 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.

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" <(E-Mail Removed)> wrote in message
news:AFCD29DD-26C5-4495-B82E-(E-Mail Removed)...
> 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.