Hi Bob,

That means that if I want to see the "cummulative" TOP5 all at "once", I use
5 different arrayformulas (and the 5 helper cells in your case) ...
it is flexible enough for my case.
I am just exploring the power of array-formulas and was wondering whether it
could be done with 1?!

Jen

"Bob Phillips" wrote in message
...
=SUM(LARGE($D$5:$D$18,ROW(INDIRECT("1:"&A1))))

and put the Topn number in A1


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Jen" wrote in message
...
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