MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Gradebook Averages


Posted by Loretta on February 28, 2001 8:50 AM


In our elementary building we are using Excel 97 as a gradebook and all students' scores are entered as percentages. I am looking for a formula that will give me the percentage of students who are at or above 85% in a given skill. We (I) have been playing with this for about 3 years now.

Thanks in advance.


Posted by David Hawley on February 28, 2001 1:31 PM

Hi Lorreta


If you percentages are in column A then try:

=COUNTIF(A1:A500,">=0.85")/COUNT(A1:A500)

And format you cell as a percentage


Dave

OzGrid Business Applications

Posted by Aladin Akyurek on February 28, 2001 2:05 PM

See her repost. *NT*

In our elementary building we are using Excel 97 as a gradebook and all students' scores are entered as percentages. I am looking for a formula that will give me the percentage of students who are at or above 85% in a given skill. We (I) have been playing with this for about 3 years now.