Average of ...
 

Anyone know how to pick out the highest 4 cells of 6 cells and then calcukate
the average the 4 cells.

tnx

Hi Tudor

=SUM(LARGE(B2:B7,{1,2,3,4}))

where your range is B2:B7 is the range containing your 6 cells.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Tudor" wrote in message
...
Anyone know how to pick out the highest 4 cells of 6 cells and then
calcukate
the average the 4 cells.

tnx

Hi Julie,

I think you mean

=AVERAGE(LARGE(B2:B7,{1,2,3,4}))

Bob


"JulieD" wrote in message
...
Hi Tudor

=SUM(LARGE(B2:B7,{1,2,3,4}))

where your range is B2:B7 is the range containing your 6 cells.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"Tudor" wrote in message
...
Anyone know how to pick out the highest 4 cells of 6 cells and then
calcukate
the average the 4 cells.

tnx

Hi tnx but I 'm not sure I understand you. What do you mean with the
,{1,2,3,4} ?


"JulieD" skrev:

Hi Tudor

=SUM(LARGE(B2:B7,{1,2,3,4}))

where your range is B2:B7 is the range containing your 6 cells.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Tudor" wrote in message
...
Anyone know how to pick out the highest 4 cells of 6 cells and then
calcukate
the average the 4 cells.

tnx

Aha now I understand. Allmost. But when I use:
=ADD.IF(C6:I6;"LARGE(C5:G5;2)") it will not work.

Maybe I need to convert the LARGE(C5:G5;2) to a string. ?

It is working when I use
=ADD.IF(C6:I6;"2")

Tudor

"JulieD" skrev:

Hi Tudor

=SUM(LARGE(B2:B7,{1,2,3,4}))

where your range is B2:B7 is the range containing your 6 cells.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Tudor" wrote in message
...
Anyone know how to pick out the highest 4 cells of 6 cells and then
calcukate
the average the 4 cells.

tnx

I think I got it now. I will try to implement it in the real sheet on monday.
Maybe I ask you guys again if something comes up.

One problem is that I use a swedish Excel and it diffecult to find the right
function when translating it from english.

Tnx
TUDOR


"Tudor" skrev:

Anyone know how to pick out the highest 4 cells of 6 cells and then calcukate
the average the 4 cells.

tnx

Hi

this seems to be a different question, what are you trying to achieve with
this formula?
=ADD.IF(C6:I6;"LARGE(C5:G5;2)")

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Tudor" wrote in message
...
Aha now I understand. Allmost. But when I use:
=ADD.IF(C6:I6;"LARGE(C5:G5;2)") it will not work.

Maybe I need to convert the LARGE(C5:G5;2) to a string. ?

It is working when I use
=ADD.IF(C6:I6;"2")

Tudor

"JulieD" skrev:

Hi Tudor

=SUM(LARGE(B2:B7,{1,2,3,4}))

where your range is B2:B7 is the range containing your 6 cells.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Tudor" wrote in message
...
Anyone know how to pick out the highest 4 cells of 6 cells and then
calcukate
the average the 4 cells.

tnx

let us know how you go and feel free to ask any additional questions you
have ...

--
Cheers
JulieD


"Tudor" wrote in message
...
I think I got it now. I will try to implement it in the real sheet on
monday.
Maybe I ask you guys again if something comes up.

One problem is that I use a swedish Excel and it diffecult to find the
right
function when translating it from english.

Tnx
TUDOR


"Tudor" skrev:

Anyone know how to pick out the highest 4 cells of 6 cells and then
calcukate
the average the 4 cells.

tnx

Hi Bob

thanks ... !

--
Cheers
JulieD

"Bob Phillips" wrote in message
...
Hi Julie,

I think you mean

=AVERAGE(LARGE(B2:B7,{1,2,3,4}))

Bob


"JulieD" wrote in message
...
Hi Tudor

=SUM(LARGE(B2:B7,{1,2,3,4}))

where your range is B2:B7 is the range containing your 6 cells.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"Tudor" wrote in message
...
Anyone know how to pick out the highest 4 cells of 6 cells and then
calcukate
the average the 4 cells.

tnx