Sum the n smallest numbers

This formula will sum the smallest 3 numbers
SUM( SMALL( B2:D5, {1,2,3} ) )

{=SUM(SMALL(CellRange, ROW(INDIRECT(Row(CellRange) & ":" & Rows(CellRange)))))}

Built-in Functions

SUM - The total of the numerical values in a list, table or cell range.
SMALL - The kth smallest value in a list, table or cell range.
ROW - The row number of a cell reference.
INDIRECT - The value of a given cell reference specified by a text string.

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