Average

[niting]

Hey


Could you help me with calculating Average of a range without max and min values. I tried but it is very lenghty. Any shortcut???


Thanks

 

[Hui]

=Average(Range)

 

[xld]

Try this array formula


=AVERAGE(IF((rng<>MAX(rng))*(rng<>MIN(rng)),rng))

 

[niting]

Hey,


Teh formula does not seem to work.


Could you suggest an alternative??


Thanks

 

[Hui]

Niting

It is an array formula

So you need to press Ctrl Shift Enter instead of just Enter when you enter it