# Golf comp calculation needed for handicaps - average and median formulas I think

#### shaneb

##### Board Regular
Hi All
I'm trying to find a formula that will calculate the following:
Out of 9 scores I want the formula to select the median 5 scores and then calculate the average of those 5 selected scores.
For example: scores of 58, 41, 29, 45, 33, 46, 42, 36, 37
I want the formula to select the 5 median scores - 36, 37, 41, 42, 45
And then calculate the average of those 5 scores.
I'm having trouble how I can select the 5 middle scores.
Any help would be appreciated
Cheers

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

#### AndyPandy27

##### Board Regular
Hi shaneb,

Assuming your 9 scores are in A1:A9, use the array formula:

=SUM(LARGE(A1:A9,{3,4,5,6,7}))/5

Make sure to enter this using CTRL+SHIFT+ENTER.

#### Andrew Poulsom

##### MrExcel MVP
To avoid having to press Ctrl+Shift+Enter you can use:

=SUMPRODUCT(LARGE(A1:A9,{3,4,5,6,7}))/5

#### shaneb

##### Board Regular
Thanks AndyPandy27. I think that has given me what I am after. Can you just tell me what the "LARGE" function does?
Cheers
Shane

Thanks Andrew.

#### AndyPandy27

##### Board Regular
Hi shaneb,

Absolutely - the Large function returns the k-th largest number in a data set.

The formula syntax is =Large(array,k)

Where array is the list of values you're choosing, and k is an integer which refers to which largest number you want to return; e.g. if k = 5, then the formula would return the 5th largest number in the array you specified.

Replies
1
Views
343
Replies
5
Views
332
Replies
0
Views
244
Replies
5
Views
185
Replies
5
Views
229

1,195,650
Messages
6,010,920
Members
441,572
Latest member
keobongda8812

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back