[Solved] Averaging the top 10 scores out of 20

[mrmark]

Good Morning,
I work at a golf course and we have a weekly outing. Each week, I post the scores and their averages. Formula for that is not a problem. We are in week 7 and when we get to week 11, I need to change my formula to give me the top 10 scores only and to give me their average score. Thank you for any help.

[Zizi64]

Use a helper table filled-in with 10 formulas by usage the function LARGE() Then calculate the average of the helper table.

Note:
For the state " less than 10 data exists", you need use a condition in the formulas to examine the COUNT() of the data.

[Villeroy]

Pivot tables are easy.

[MrProgrammer]

Hi, and welcome to the forum.

We are in week 7 and when we get to week 11, I need to change my formula to give me the top 10 scores only and to give me their average score

=AVERAGE(IF(COUNT(cells)<11;cells;LARGE(cells;{1;2;3;4;5;6;7;8;9;10})))
Type that then press ⇑⌘Enter on a Mac, Ctrl+Shift+Enter on other platforms. If you press Enter by accident, use Edit → Delete Contents → Delete All → OK, then retype the formula and try again. If you need any additional assistance attach a document demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself).

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[mrmark]

it worked great, thank you