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 in a list, table or cell range.
LARGE - The kth largest value in a list, table or cell range.
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