Count number of cells that are between certain percentages
I have attached a spreadsheet.
I need a formula to count the number of students from each school, in each grade, that are between 95%-100%, 90-94%, 80-89%, 70-79%, 60-69%, 50-59%, and below 50%.
So for example, there are 9 students in grade 1 at the community school that are between 90-94% and 3 between 80-89% and 2 below 50%.
Can you please help? I did get a formula from here before, but now my I have to break down the percentages further and I can't do it.
Thank you so much! :)))
Attachment | Size |
---|---|
November 2014 Student Attendance by Percent - help.xlsx | 29.92 KB |
Here you go
100-95
=COUNTIFS(C:C,">=95%",C:C,"<=100%")
94-90
=COUNTIFS(C:C,">=90%",C:C,"<=94%")
89-80
=COUNTIFS(C:C,">=80%",C:C,"<=89%")
79-70
=COUNTIFS(C:C,">=70%",C:C,"<=79%")
69-60
=COUNTIFS(C:C,">=60%",C:C,"<=69%")
59-50
=COUNTIFS(C:C,">=50%",C:C,"<=59%")
Below 50
=COUNTIFS(C:C,">=0%",C:C,"<50%")