try this ARRAY formula which must be entered with ctrl+shift+enter. ONE line

=(SUM(IF(A3:A9="Front",B3:B9))-MIN(IF(A3:A9="Front",B3:B9))-MAX(IF(A3:A9="Fr
ont",B3:B9)))/(COUNTIF(A3:A8,"Front")-2)

--
Don Guillett
SalesAid Software

"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