Average the n largest numbers

AVERAGE( LARGE( B2:D5, {1,2,3} )


Built-in Functions

AVERAGE - The arithmetic mean of non blank cells in a list, table or cell range.
LARGE - The kth largest value in a list or array of numbers.


Related Formulas

Average the n smallest numbers
Find the n largest numbers
Count the n largest numbers
Sum the n largest numbers


© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top