Okay, so how about

=AVERAGE(LARGE(IF(B1:B20="Front",C1:C20),ROW(INDIR ECT("2:"&COUNTIF(B1:B20,"F
ront")-1))))

still an array formula

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Don Guillett" wrote in message
...
But this average needs to throw out the high and low.


--
Don Guillett
SalesAid Software

"Bob Phillips" wrote in message
...
=AVERAGE(IF(B1:B20="Front",C1:C20))

which is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sonofroy" wrote in message
...
Hi I have a golf handicapping spredsheet set up like this
B C
Front 41
Back 30
Front 53
Back 43
Front 37
Back 29

I am trying to get an average for the data in "C" for the "Front" and
then
seperately for the "Back"

But this average needs to throw out the high and low.

SUMPRODUCT will not give me a count of Fronts and Backs, and AVERAGE
will
not work because I can not get a min function to leave out zeros.

Help Please!
Thanks a bunch