LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
golf handicap 4 of last 5 scores Golf.nut1 Excel Discussion (Misc queries) 15 April 3rd 08 06:11 AM
Problem Importing Fixed Width Data [email protected] New Users to Excel 7 September 15th 06 01:42 AM
Calculating average scores from multiple sheets' information quailhunter Excel Worksheet Functions 2 October 16th 05 10:37 PM
Football Scores Number_8 Excel Discussion (Misc queries) 4 August 12th 05 05:46 PM
Golf Handicap Using Last 5 Scores Golf League Schedule Excel Worksheet Functions 5 May 13th 05 12:14 AM


All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"