Sum (throw out highest and lowest)

T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top