| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I have 12 scores over 12 weeks . I want to average the highest 5
|
|
#2
|
|||
|
|||
|
Here is an example
=SUMPRODUCT(LARGE(A1:A12,{1,2,3,4,5})) -- HTH RP (remove nothere from the email address if mailing direct) "Directioneng" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| plotted Average | Charts and Charting in Excel | |||
| What is this kind of average called? | Excel Worksheet Functions | |||
| Golf Handicap Using Last 5 Scores | Excel Worksheet Functions | |||
| average function in Excel 2002 | New Users to Excel | |||
| How can I total the top 9 scores of 12 weeks in a sporting contest | Excel Discussion (Misc queries) | |||
Linear Mode
