One way ..

Put in H71: =1/3*(SUM(B73:B77)-MAX(B73:B77)-MIN(B73:B77))

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"SYBS" wrote in message
...
A scoresheet in excel returns 5 separate scores. I need to ignore the
highest and the lowest figures and average the other three to get a
result.
How do I do this. I have tried
=IF(H71<B74,B75,B76,B77, IF(H71B74,B75,B76,B77,"0","H71")
h71 IS THE CELL CONTAINING THE SCORE WHICH SHOWS IN B73. THE OTHER FOUR
SCORES ARE ALL SHOWN IN B74, B75,B76 AND B77. i ONLY WANT THE MIDDLE
THREE
SCORES TO BE AVERAGED AND PRODUCE A RESULT. HELP WOULD BE MOST
APPRECIATED.