count formula
 

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.

count formula
 

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

If this post helps click Yes
---------------
Jacob Skaria


"ramesh" wrote:

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.