Gradebooks
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:
=COUNTIF(A2:A12,">="&B1)/COUNT(A2:A12)
Aladin
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
