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.
