Average cells using the n largest numbers
AVERAGE( LARGE( B2:D5, {1,2,3} )
Built-in Functions
AVERAGE - The arithmetic mean of the numerical values.
LARGE - The kth largest numerical value.
Related Formulas
Average the n smallest numbers
Find the n largest numbers
Count the n largest numbers
Sum the n largest numbers
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top