count formula

  • Thread starter Thread starter ramesh
  • Start date Start date
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.
 
If the total marks are in the range B1:G1 use the formula
=COUNTIF(B1:G1,"<40")

If this post helps click Yes
 
Back
Top