count formula

R

ramesh

i have a data of students results. there are 6 subjects. each subject has
internal, external and total marks. in every subject a student has to score
40 (including internal and externalmarks) to pass. so i have to count who
got less than 40 in how many subjects? i.e., total no.of subjects failed.
pls. what formula i use.
 
J

Jacob Skaria

If the total marks are in the range B1:G1 use the formula
=COUNTIF(B1:G1,"<40")

If this post helps click Yes
 

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

Top