Average the n smallest numbers
AVERAGE( SMALL( B2:D5, {1,2,3} )
Built-in Functions
AVERAGE - The arithmetic mean of non blank cells in a list, table or cell range.
SMALL - The kth smallest value in a list or array of numbers.
Related Formulas
Average the n largest numbers
Find the n smallest numbers
Count the n smallest numbers
Sum the n smallest numbers
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top