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

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

"Belzbub" wrote in message
...
I just get error when i try it...

Hi

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

Arvi Laanemets


"Don Guillett" wrote in message
...
does this help
=SUM(LARGE(E1:E14,{1,2,3}))/3

--
Don Guillett
SalesAid Software

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

"Belzbub" wrote in message
...
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"
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" wrote in message
...
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" wrote in message ...
Still error, hm.....

Everything is numbers yes.

David McRitchie skrev:

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

"Belzbub" wrote in message ...
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<attarkon.ee )


"Belzbub" wrote in message
...
Still error, hm.....