Sum (throw out highest and lowest)

[Timothy Garrison]

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 Preview
http://www.eggheadcafe.com/tutorial...8-46031e699b2e/wpf-printing-and-print-pr.aspx

 

[ryguy7272]

=SUM(A1:A29,-LARGE(A1:A29,{1})-SMALL(A1:A29,{1}))
try that.

HTH,
Ryan---

 

[minyeh]

=SUM(LARGE(A1:A5,{2,3,4}))

would give an cleanier formula if ur judges is always 5 ppl as u
stated.
if the number of judges changes all the times,
then pete and ryan's formula would work great

there's another way to do this, though much less intuitive

=TRIMMEAN(A1:A5,2/COUNT(A1:A5))*(COUNT(A1:A5)-2)