Averaging x numbers while excluding others

[ew84y8]

Is there a way to show the average of the top ten numbers in a column which contains a lot of random blank spaces? The column always changes, but I want a code that will always show the average of only the top ten, while excluding blank spaces and extra numbers.

[CARACALLA]

It would help if you attached a sample Excel workbook,not an image

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Do not try to use the Paperclip icon, as this does not work on this forum.

[shg]

	a	b	c
1
2
3
4
5	1	5.5	b5: {=average(a5:index(a:a, small(if(isnumber(a5:a25), row(a5:a25)), 10)))}
6
7	2
8	3
9
10
11	4
12	5
13	6
14
15
16	7
17	8
18
19	9
20	10
21
22	11
23	12
24	13
25	14

[kvsrinivasamurthy]

Data in A3:A21

=AVERAGEIF(A3:A21,">="&LARGE(A3:A21,10))