How can I create a formula that averages only the highest 5 numbers out of 7? Example:
A1: 25
B1: 19
C1: 30
D1: 28
E1: 28
F1: 29
G1: 22
The formula should average all except cells B1 & G1.
Thank you,
Linda
How can I create a formula that averages only the highest 5 numbers out of 7? Example:
A1: 25
B1: 19
C1: 30
D1: 28
E1: 28
F1: 29
G1: 22
The formula should average all except cells B1 & G1.
Thank you,
Linda
Last edited by lbabli; 12-28-2008 at 09:52 PM. Reason: spelling
Try
=AVERAGE(LARGE(A1:G1,{1,2,3,4,5}))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks