Hi,

This ARRAY formula (Ctrl-Shift-Enter) :

=TRIMMEAN(IF(COLUMN(B5:R5)=LARGE(IF(B5:R5,COLUMN( B5:R5)),5),IF(B5:R5,B5:R5)),0.
4)

Regards,

Daniel M.

"Dick Gwin" wrote in message
...
I have golf scores in columns b thru r that are entered weekly.
The league uses handicaping based on the last 5 scores, eliminating
the lowest score and the highest score, averaging the remaining 3 scores.
The league uses a rotation system so that a player may have his last
5 scores spread over 7 or 8 weeks (columns). I need a formula in column s
that
looks back thru the weeks & finds the last 5 scores for calculating the
handicap.
The following formula is only applicable if the last 5 are all together in
5 consecutive columns.
(SUM($C5:$G5)-MAX($C5:$G5)-MIN($C5:$G5))/3)-(36))

R Gwin