Brute-force..........

=(LARGE(B:B,1)+LARGE(B:B,2)+LARGE(B:B,3)+LARGE(B:B ,4)+LARGE(B:B,5))/SUM(B:B)

all on one line, watch out for word wrap.

Vaya con Dios,
Chuck, CABGx3



"A.S." wrote:

Sample data:
Rank Minutes
1 34792
2 28301
3 26718
4 19282
5 16849
6 11002
...1500 0

Basically I then request to view let's say the top 5...then I need a formula
that will look for the top 5 minutes then determine what percentage that is
of the whole. For example, in this case, let's say the sum of all 1500
entries is 592,000. And I say top 3..then in this case the formula would
calculate 34792+28301+26718=89811/592,000 = 15% of total data. If I request
top 5 then it would give me 34792+28301+26718+19282+16849=125582/592,000=21%.
Any ideas on the formula?

Thanks.