Suppose your 5 results are in A1:A5. Then you could use this formula:

=SUM(A1:A5)-MAX(A1:A5)-MIN(A1:A5)

to give you the sum of the middle 3 scores.

Hope this helps.

Pete

On Nov 25, 3:51*pm, Timothy Garrison wrote:
I am working on a contest scoring sheet for the California State Old Time fiddlers Association and it is contest policy to throw out the highest score and the lowest score and add the remaining middle (3) judges scores. *(There are generally 5 judges - don't think there would ever be more than that.)
* The total of the middle three is used for future ranking points added to future scores, so "average" won't work in this application. *Right now we are working this out manually - sure woudl be sweet to be able to have a formula that works it out for us. *Thanks for any help.
Timothy Garrison - Redding CA

EggHeadCafe - Software Developer Portal of Choice
WPF Printing and Print Previewhttp://www.eggheadcafe.com/tutorials/aspnet/9cbb4841-8677-49e9-a3a8-4...