Finding Average of certain numbers in a range of cells

[clftn2929]

Hello,

I am trying to find the average of range of cells, but I only want the 7 highest numbers in a range of ten numbers.

can anyone please help with a formula.....

thank you very much

 

[Scott Huish]

Perhaps:

=AVERAGE(LARGE($A$1:$A$10,ROW(INDIRECT("1:7"))))

Confirm with CTRL-SHIFT-ENTER, rather than just Enter.

 

[big_mac]

Confirm with CTRL-SHIFT-ENTER, rather than just Enter.

compare 2 list.xls
	A	B	C	D	E	F	G
1	1	98		94.85714286
2	2	96
3	3	94
4	4	94
5	5	90
6	6	90
7	7	70
8	8	65
9	9	97
10	10	95
11
Sheet1