One way:

=AVERAGE(LARGE(C1:C11,{3,4,5,6,7,8,9}))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Skip" wrote in message
oups.com...
Excel 2003.

I have a column of 11 numbers.
I would like to throw out the two highest,
the two lowest, and get an average of the
remaining 7.
Any help is greatly appreciated.
Thanks Skip