View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
A.S. A.S. is offline
external usenet poster
 
Posts: 79
Default searching then averaging

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.