• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Average

N

niting

New Member
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
 
Try this array formula


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

It is an array formula

So you need to press Ctrl Shift Enter instead of just Enter when you enter it
 
You must log in or register to reply here.
Back
Top