Average of top 3 numbers.

Hi, im making a worksheet for our shooting results. I need the average of the
top 3 results from collum E6 to W6 and top 3 reults from Y6 to AJ6. Can
anyone help me with this one??

does this help
=SUM(LARGE(E1:E14,{1,2,3}))/3

--
Don Guillett
SalesAid Software
donaldb@281.com
"Belzbub" <Belzbub@discussions.microsoft.com> wrote in message
news:761625F9-9AB4-4B29-A37A-1EA9600ED61B@microsoft.com...
> Hi, im making a worksheet for our shooting results. I need the average of
> the
> top 3 results from collum E6 to W6 and top 3 reults from Y6 to AJ6. Can
> anyone help me with this one??

I just get error when i try it...

perhaps you didn't change from my EXAMPLE. Try this.
=AVERAGE(LARGE($E$6:$W$6,{1,2,3}))

--
Don Guillett
SalesAid Software
donaldb@281.com
"Belzbub" <Belzbub@discussions.microsoft.com> wrote in message
news:FAB5FB64-E0F2-4285-9B1B-E9BA0B201E01@microsoft.com...
>I just get error when i try it...

Hi

Maybe
=AVERAGE(LARGE(E1:E14,{1;2;3}))

Arvi Laanemets


"Don Guillett" <donaldb@281.com> wrote in message
news:uZEy6S48FHA.2036@TK2MSFTNGP14.phx.gbl...
> does this help
> =SUM(LARGE(E1:E14,{1,2,3}))/3
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> "Belzbub" <Belzbub@discussions.microsoft.com> wrote in message
> news:761625F9-9AB4-4B29-A37A-1EA9600ED61B@microsoft.com...
> > Hi, im making a worksheet for our shooting results. I need the average
of
> > the
> > top 3 results from collum E6 to W6 and top 3 reults from Y6 to AJ6. Can
> > anyone help me with this one??
>
>

or even

=AVERAGE(LARGE($E$1:$E$14,{1,2,3}))

--
Don Guillett
SalesAid Software
donaldb@281.com
"Belzbub" <Belzbub@discussions.microsoft.com> wrote in message
news:761625F9-9AB4-4B29-A37A-1EA9600ED61B@microsoft.com...
> Hi, im making a worksheet for our shooting results. I need the average of
> the
> top 3 results from collum E6 to W6 and top 3 reults from Y6 to AJ6. Can
> anyone help me with this one??

=AVERAGE(LARGE(E6:W6,{1,2,3}))

Same for other range.


Gord Dibben Excel MVP


On Sun, 27 Nov 2005 10:50:09 -0800, "Belzbub"
<Belzbub@discussions.microsoft.com> wrote:

>Hi, im making a worksheet for our shooting results. I need the average of the
>top 3 results from collum E6 to W6 and top 3 reults from Y6 to AJ6. Can
>anyone help me with this one??

Still error, hm.....

What kind of error?

--
Regards,

Peo Sjoblom

(No private emails please)


"Belzbub" <Belzbub@discussions.microsoft.com> wrote in message
news:D96D1A20-01E0-4092-9BBD-1EFD72B110A8@microsoft.com...
> Still error, hm.....

Just a thought here...

If you are typing the formula, instead of copy/paste, did you notice the
curly braces in the formula?

=AVERAGE(LARGE(E6:W6,{1,2,3}))
The character before the 1 is on the [ key (you hold down Shift to get it).
The character after the 3 is on the ] key (again, hold down Shift to get it).

Does that help?

***********
Regards,
Ron


"Belzbub" wrote:

> Still error, hm.....

Tried to type it in but still error. It popps up a window with: The formula
you typed contains a error". Can i send you the excel sheet so you can try it?

Ron Coderre skrev:

> Just a thought here...
>
> If you are typing the formula, instead of copy/paste, did you notice the
> curly braces in the formula?
>
> =AVERAGE(LARGE(E6:W6,{1,2,3}))
> The character before the 1 is on the [ key (you hold down Shift to get it).
> The character after the 3 is on the ] key (again, hold down Shift to get it).
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
>
> "Belzbub" wrote:
>
> > Still error, hm.....

Nah...don't send the worksheet...

Just copy the below formula
(paint through it using your mouse then right click and select Copy)
=AVERAGE(LARGE(E6:W6,{1,2,3}))

Then, click on any cell on your worksheet that is NOT in row 6.
Right click and select Paste.

Does that help?

***********
Regards,
Ron


"Belzbub" wrote:

> Tried to type it in but still error. It popps up a window with: The formula
> you typed contains a error". Can i send you the excel sheet so you can try it?
>
> Ron Coderre skrev:
>
> > Just a thought here...
> >
> > If you are typing the formula, instead of copy/paste, did you notice the
> > curly braces in the formula?
> >
> > =AVERAGE(LARGE(E6:W6,{1,2,3}))
> > The character before the 1 is on the [ key (you hold down Shift to get it).
> > The character after the 3 is on the ] key (again, hold down Shift to get it).
> >
> > Does that help?
> >
> > ***********
> > Regards,
> > Ron
> >
> >
> > "Belzbub" wrote:
> >
> > > Still error, hm.....

Is everthing a number. test with =isnumber(a1)

"Belzbub" <Belzbub@discussions.microsoft.com> wrote in message news:D96D1A20-01E0-4092-9BBD-1EFD72B110A8@microsoft.com...
> Still error, hm.....

Everything is numbers yes.

David McRitchie skrev:

> Is everthing a number. test with =isnumber(a1)
>
> "Belzbub" <Belzbub@discussions.microsoft.com> wrote in message news:D96D1A20-01E0-4092-9BBD-1EFD72B110A8@microsoft.com...
> > Still error, hm.....
>
>
>

Sorry was a bit early. When i mark the whole area i get FALSE.


> Everything is numbers yes.

Hi

What is array delimiter in window's International settings for your comp?
Maybe semicolon! (Check a version of Don's formula I posted yesterday!)


--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )


"Belzbub" <Belzbub@discussions.microsoft.com> wrote in message
news:D96D1A20-01E0-4092-9BBD-1EFD72B110A8@microsoft.com...
> Still error, hm.....