=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