How to Sum Occurences [closed]

asked 2014-05-09 13:28:32 +0200

Coda847 gravatar image

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!

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-22 10:50:27.789655