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))))}
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))))}
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks