Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to sum the 3 best scores for each country in a contest?
To sum the 3 highest numbers, following functions can be used in a
really nice combination: =SUM(LARGE(A1:A100, {1,2,3} ) ) But how to add an condition to it? Example: Column A below are the scores for induvudual persons in a contest. Column B below is the country they are competing for .. How to add the sum of the 3 best scores for each country ? The correct answer should be 213+199+187=599 for USA and 198+158+135=491 for Canada. A B 141 USA 199 USA 135 CAN 187 USA 158 CAN 145 USA 213 USA 198 CAN 120 USA 180 CAN Really looking forward for the experts to crack this one. Preferably without using VB. Regards Dan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to sum the 3 best scores for each country in a contest?
On Fri, 7 Aug 2009 15:38:03 -0700 (PDT), Persson wrote:
To sum the 3 highest numbers, following functions can be used in a really nice combination: =SUM(LARGE(A1:A100, {1,2,3} ) ) But how to add an condition to it? Example: Column A below are the scores for induvudual persons in a contest. Column B below is the country they are competing for . How to add the sum of the 3 best scores for each country ? The correct answer should be 213+199+187=599 for USA and 198+158+135=491 for Canada. A B 141 USA 199 USA 135 CAN 187 USA 158 CAN 145 USA 213 USA 198 CAN 120 USA 180 CAN Really looking forward for the experts to crack this one. Preferably without using VB. Regards Dan See answer in other NG. Please don't multi-post --ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to sum the 3 best scores for each country in a contest?
Persson wrote:
To sum the 3 highest numbers, following functions can be used in a really nice combination: =SUM(LARGE(A1:A100, {1,2,3} ) ) But how to add an condition to it? Example: Column A below are the scores for induvudual persons in a contest. Column B below is the country they are competing for . How to add the sum of the 3 best scores for each country ? The correct answer should be 213+199+187=599 for USA and 198+158+135=491 for Canada. A B 141 USA 199 USA 135 CAN 187 USA 158 CAN 145 USA 213 USA 198 CAN 120 USA 180 CAN Really looking forward for the experts to crack this one. Preferably without using VB. Regards Dan Answered in MPE. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to sum the 3 best scores for each country in a contest?
On 8 Aug, 01:11, Ron Rosenfeld wrote:
On Fri, 7 Aug 2009 15:38:03 -0700 (PDT), Persson wrote: To sum the 3 highest numbers, following functions can be used in a really nice combination: * * * * * * * * * * * * * * * * =SUM(LARGE(A1:A100, {1,2,3} ) *) But how to add an condition to it? Example: Column A below are the scores for induvudual persons in a contest. Column B below is the country they are competing for . How to add the sum of the 3 best scores for each country ? The correct answer should be 213+199+187=599 for USA and 198+158+135=491 for Canada. A * * * * *B 141 * *USA 199 * *USA 135 * *CAN 187 * *USA 158 * *CAN 145 * *USA 213 * *USA 198 * *CAN 120 * *USA 180 * *CAN Really looking forward for the experts to crack this one. Preferably without using VB. Regards Dan See answer in other NG. *Please don't multi-post --ron Hi Thank you all for the great solution! Sorry I had to multipost, but this was a priority 1 to get an anser quick, the contest is starting within 2 hours. Once again, thank you. Regards Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to sum the 3 best scores for every country in an contest? | Excel Worksheet Functions | |||
typing 'Up Country' ends up as Up Country' ? | Excel Discussion (Misc queries) | |||
rank scores show ties and add top four scores | Excel Programming | |||
excel golf scores, how do I add the scores for all par 3's etc | Excel Worksheet Functions | |||
How can I total the top 9 scores of 12 weeks in a sporting contest | Excel Discussion (Misc queries) |