Showing Cummulative Top5 results with an array-formula...?
Hi There,
Below are array-formulas, so use Ctrl+Shift+Enter:
I can show the Top5 of my range D5:D200 as follows:
=LARGE($D$5:$D$200,ROW(INDIRECT("1:5")))
Suppose this results in a range with output: {1000,500,250,125,0}
I can show the sum of the Top5 as follows:
=SUM(LARGE($D$5:$D$18,ROW(INDIRECT("1:5"))))
Results in {1875}
What I would like to achieve is an array-formula that shows:
SumTop5-values: Being: 1875
SumTop4-Values: Being: 1875
SumTop3-values: Being:1750
SumTop2-values: Being 1500
SumTop1-Value: Being 1000
Hope you cam help?
Thanks in advance,
jen
|