Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Am totaling scores for each judge for a contest, and each entry is
judged in 3 categories. Need to sum the remaining scores, by tossing out that judges scores. We need to disregard all numbers from Judge 2 in the total because they have the lowest total score. Judge 1 Judge 2 Judge 3 Red 6 7 5 Blue 9 2 6 Green 7 1 4 TOTAL 22 10 15 Need to remove all of Judge 2's scores from the individual totals of red, blue and green because Judge 2 had the lowest total score. (There are actually 6 judges total.) Answers: Red should be 11, Blue should be 15, and Green should be 11. TIA for any thoughts. Pierre |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
golf handicap 4 of last 5 scores | Excel Discussion (Misc queries) | |||
Problem Importing Fixed Width Data | New Users to Excel | |||
Calculating average scores from multiple sheets' information | Excel Worksheet Functions | |||
Football Scores | Excel Discussion (Misc queries) | |||
Golf Handicap Using Last 5 Scores | Excel Worksheet Functions |