Question

Ramesh Sir has a list of students with their marks and remarks as ‘Pass’ and ‘Fail’. He wants to count the number of students who have passed. Which function in MS-Excel will he use? ​

Answer 1

Answer:

To return "Pass" when any 4 subjects have a passing score, and "Fail" when not, you can use a formula based on the IF and COUNTIF functions. In the example shown, the formula in I5 is:

=IF(COUNTIF(C5:H5,">=70")>=4,"Pass","Fail")

where 70 represents the passing score for all subjects.

Explanation:

Working fron the inside out, this formula uses the COUNTIF function to count passing scores in all six subjects:

COUNTIF(C5:H5,">=70") // count passing subjects

The result in I5 is 3, in I6 is 5, and in I7 is 6. It's a good idea to use COUNTIF alone

hope it helps you

stay safe and warm

stay at home ❤️