| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
In Excel, how to select and then add up the best 6 scores out of 7
How do I set up a spreadsheet which will select and then add up the best six
arithmetical scores out of 7? Any help would be appreciated. The version is Excel 2002 with SP3 running in Windows XP Home version. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
In Excel, how to select and then add up the best 6 scores out of 7
Let's say you have the seven scores in column A and best is highest ( not
like golf ), then in an un-used cell enter: =SUM(A1:A7)-MIN(A1:A7) -- Gary's Student "Camashco" wrote: How do I set up a spreadsheet which will select and then add up the best six arithmetical scores out of 7? Any help would be appreciated. The version is Excel 2002 with SP3 running in Windows XP Home version. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel golf scores, how do I add the scores for all par 3's etc | Excel Worksheet Functions | |||
| Auto select highest 25 scores. | Excel Worksheet Functions | |||
| Anyone have an Excel template for Skeet /Trap Scores? | Excel Discussion (Misc queries) | |||
| Can Excel list order according to Total scores? | Excel Worksheet Functions | |||
| Can Excel count the number of scores within a range? | Excel Worksheet Functions | |||
Linear Mode
