Average of ...

T

Tudor

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

tnx
 
J

JulieD

Hi Tudor

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

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

Tudor

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


"JulieD" skrev:
 
T

Tudor

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:
 
T

Tudor

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:
 
J

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

JulieD

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