Getting the percentage of passes in school exam

  • Thread starter Thread starter joe serrano
  • Start date Start date
J

joe serrano

I am sure it is the easiest thing in the orld, but I am stuck.

How can I get the number of passed students using Excel formula:

The pass would be in 5 out of ten.

Thanks in advance.
 
one way:

Say your scores are in J2:J21:

=COUNTIF(J2:J21,">5")/COUNT(J2:J21)

Format the cell as a percentage.
 
thanks,

Once I saw the formula you used, it occured to me.

Sometimes the easiest things are the hardest to solve.


joe
 
Are you a teacher?
Do you let students say to you "Sometimes the easiest things are the hardest
to solve" ?

Best wishes
 
Back
Top