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

=COUNTIF(B:B,"<" & 50)
--
Gary''s Student - gsnu200787

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

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

Regards,
Paul

--

"Gary''s Student" <GarysStudent@discussions.microsoft.com> wrote in message
news:02DC6766-CDEC-4C68-9AEC-87CB60ED822A@microsoft.com...
> =COUNTIF(B:B,"<" & 50)
> --
> Gary''s Student - gsnu200787

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.

"excel determine no failed." wrote:

> 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