So I have a worksheet that shows tests that students have taken and what score they received. For example
1 Bob Science 72%
2 Jill Math 90%
3 Lily History 55%
4 John Math 52%
5 Mary Science 81%
In another worksheet I have a summary page that looks like this:
number of students: 5
number of tests taken: 5
average score: 70%
number passed: ?
number failed: ?
The number passed and the number failed is where I am stuck. I need a formula that will count how many students got a 59% or lower. So the answer for number passed would be 3 and number failed would be 2. Thanks for any help!