formula help

  • Thread starter Thread starter excel determine no failed.
  • Start date Start date
E

excel determine no failed.

Good day, I am a lecturer and would like help with the following problem : I
have 10 students in a classs and the pass mark is 50% I want to determine the
no failed i.e how many students got below 50%

Test Marks

stud 1 65
stud 2 50
stud 3 23
stud 4 90
stud 5 15
stud 6 88
stud 7 35
stud 8 44
stud 9 39
stud 10 95

no failed 5

how can this be done?Is there a function I can use?

Thanking you

Cheers
 
Unless there is some limitation in some XL versions, I think it's a little
simpler:

=COUNTIF(B:B,"<50")

Regards,
Paul
 
Good day
Thanks for the help, it worked like a charm, now I can apply it to all other
results. Take care and have a wonderful day I have learnt something new

Cheers.
 
Back
Top