| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference Between Highest And Lowest? | Excel Discussion (Misc queries) | |||
| Graph Highest to Lowest. | Excel Discussion (Misc queries) | |||
| How do I set up a formula to throw out the 2 lowest scores? | Excel Worksheet Functions | |||
| Highest High and Lowest Low | Excel Discussion (Misc queries) | |||
| Sort from lowest to highest | Excel Worksheet Functions | |||
Threaded Mode
