Top Percentages Based on Score Band

Hello!

I am trying to find the top 5%, 10%, 70%, and bottom 10% of a group of people based on a score. I'm trying to do this as a percent of the total scores and want to be sure I did this correctly, or if there is a formula I can use to easily apply this to the other groups I have to rank.

I've attached an example of the data I'm using. Would I just do as I did in the example, sum up total scores in column C, divide each score by the total, and then group each manually based on the parameters? Is there a formula I can use to make this easier? Any help would be greatly appreciated!

Thanks!

Maybe you want COUNTIFS with PERCENTILe. For instance

top 5%: =COUNTIFS($C$3:$C$33,"<="&PERCENTILE($C$3:$C$33,100%),$C$3:$C$33,">="&PERCENTILE($C$3:$C$33,95%))
next 15%: =COUNTIFS($C$3:$C$33,"<="&PERCENTILE($C$3:$C$33,95%),$C$3:$C$33,">="&PERCENTILE($C$3:$C$33,80%))
etc.

Thanks for your answer Bob!

I input that into my worksheet, and it seems to be double counting some as my total doesn't add up to the 31 people. Any idea why that would happen? I've attached my updated worksheet with your formulas applied.

Also I was looking for something that would flag each score, I suppose I could do this with conditional formatting, but when I apply that it does not match the formula you provided. Thoughts?

Thanks again!