Difficulty 2 of 5 · about 3 min
Count students at or above a pass mark held in a cell
Student results are in A2:C11: name in column A, class in column B and score out of 100 in column C. The class to check is typed in E2 and the pass mark is in F2. In G2, write a formula that counts the students in that class whose score is greater than or equal to the pass mark. The comparison must read the pass mark from F2, not have the number typed into the formula.
Loading grid…