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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Assigning values to a variable set 1
Help with formula 0
Vlookup with 3 viariables 2
getting specific data from one page to another 3
Merge 2 Files 0
Conditional format based on criteria 2
need to display maximum value of corresponding values in excel 2

Top