For my project I need some help with excel formula. I need to count students who have Low grades in 3 or more subjects. I am not able to formulate the formula. Attached is a hypothetical sample. What I need to derive is that there are 2 students who are Low Achievers and 1 student who is High achiever. How do I do that in Excel using formula?
Student ID Subject Grade
100 Eng Low
100 Hind High
100 Math High
100 Science High
100 SST Low
101 Eng High
101 Hind Low
101 Math Low
101 Science Low
101 SST High
104 Eng High
104 Hind Low
104 Math High
104 Science Low
104 SST Low
Student ID Subject Grade
100 Eng Low
100 Hind High
100 Math High
100 Science High
100 SST Low
101 Eng High
101 Hind Low
101 Math Low
101 Science Low
101 SST High
104 Eng High
104 Hind Low
104 Math High
104 Science Low
104 SST Low