View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
 
Posts: 193
Default Take out judges scores

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