Sum the n largest numbers
This formula will sum the largest 3 numbers
SUM( LARGE( B2:D5, {1,2,3} ) )
This formula will sum the largest 4 numbers
{=SUM(LARGE(cellrange, {1,2,3,4}))}
LARGE(B2:D5, ROW(INDIRECT("1:3")))
When you use this formula the values will not be adjusted when you insert rows or move the array formula
=SUMPRODUCT(LARGE(CellRange,{1,2,N}))
{=SUM(LARGE(CellRange, ROW(INDIRECT(Row(CellRange) & ":" & Rows(CellRange)))))}
Built-in Functions
SUM - The total of the numerical values.
LARGE - The kth largest numerical value.
SUMPRODUCT - The sum of the product of one or more arrays of values.
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