Average of ...

[Guest]

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

tnx

 

[JulieD]

Hi Tudor

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

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

 

[Bob Phillips]

Hi Julie,

I think you mean

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

Bob

 

[Guest]

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


"JulieD" skrev:

 

[Guest]

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:

 

[Guest]

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:

 

[JulieD]

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)")

 

[JulieD]

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

 

[JulieD]

Hi Bob

thanks ... !

--
Cheers
JulieD

Hi Julie,

I think you mean

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

Bob