Sum (throw out highest and lowest)
 

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/tutorials...-print-pr.aspx

Sum (throw out highest and lowest)
 

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...

Sum (throw out highest and lowest)
 

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

HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Pete_UK" wrote:

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...

.

Sum (throw out highest and lowest)
 

=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)