Those are not my real scores. Did the array formula remove zeros from the MIN
function?

"Don Guillett" wrote:

Pretty good golfer

--
Don Guillett
SalesAid Software

"sonofroy" wrote in message
...
Thanks in this formula does it throwout any zeros found in "b" column for
the
MIN?

"Don Guillett" wrote:

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