Conditional Formating/Formulas

M

MC

I have a list of students with their test scores. I want to be able to find
out how many students scored 222 or over. Then I want to find out what
percentage of student scored 222 or over. How do I do this?
 
D

David Biddulph

=COUNTIF(A1:A100,">=222")
=COUNTIF(A1:A100,">=222")/COUNT(A1:A100) and format as percentage
 
Top