formula help

[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

 

[Gary''s Student]

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

 

[PCLIVE]

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

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

Regards,
Paul

 

[excel determine no failed.]

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.