Average cells using the n smallest numbers

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


Built-in Functions

AVERAGE - The arithmetic mean of the values in a list, table or cell range.
SMALL - The kth smallest value in a list, table or cell range.


Related Formulas

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


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