I work with groups of scores in the thousands and want to find a method of breaking the whole into percentile ranges and then finding the average of each range.

I can use =average(c1:c60), =average(c61:c120) in each cell up to 100 for a group of 6000, but my problem is that the 6000 is not fixed and will increase over time.

Plus I would like to find the averages for percentile ranges of subsets of varying sizes of the large group.

I'm hoping there is a simple way to do this, but this new user's searches have not found an answer.

Thanks.