MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Loretta on February 28, 2001 9:11 AM

In our elementary school we use Excel for gradebooks and the students' scores are entered in percentages. I am looking for a formula that will tell us what percentage of the class is at or above 85% in a designated skill area, test, etc. We (I) have been playing around with this for almost 4 years.

Your help will be greatly appreciated.

Posted by Aladin Akyurek on February 28, 2001 9:25 AM

Assuming your scores as percentages are in A2:A12.

In B2 enter: =COUNTIF(A2:A12,">=85%")/COUNT(A2:A12)

You can replace 85% by 0.85 if that is the format in which you enter percentage scrores of the students.

You can do even better by entering your criteria (d.i. 85% or 0.85) in, say, B1. You can then type in B2:



Posted by Mark W. on February 28, 2001 10:32 AM

Loretta, I'd recommend that you take this opportunity
to familiarize yourself with PivotTables. Care to
describe the organization of your data?

Posted by Dave Hawley on February 28, 2001 3:51 PM

Doh! See her original post :o)

OzGrid Business Applications