» Summing the N Largest Values in a Range
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Problem: Summing the n largest values in List1 (column A) for each value of N in column B.
Solution:
Use the SUM, LARGE, ROW, and INDIRECT functions as shown in the following Array formula:
{=SUM(LARGE($A$2:$A$11,ROW(INDIRECT("1:"&B2))))}
Book Store:
No comments have been submitted.
