 # Q. count if doubt

Q. For the student database given alongside, arrive at the number of students who come under each of the grade categories.

 Student Grades Student 1 62 Student 2 92 Student 3 52 Student 4 60 Student 5 81 Student 6 66 Student 7 63 Student 8 100 Student 9 46 Student 10 87 Student 11 93 Student 12 84 Student 13 44 Student 14 71 Student 15 100 Student 16 40 Student 17 35 Student 18 73 Student 19 99 Student 20 88 Student 21 90 Student 22 90 Student 23 44 Student 24 74 Student 25 46 Student 26 74 Student 27 92 Student 28 31 Student 29 51 Student 30 59 Student 31 85 Student 32 63 Student 33 60 Student 34 83 Student 35 72 Student 36 94 Student 37 92 Student 38 92 Student 39 59 Student 40 51 Student 41 45 Student 42 89 Student 43 51 Student 44 84 Student 45 32 Student 46 73 Student 47 44 Student 48 81 Student 49 76 Student 50 89

 Min Max Grade Frequency 90 100 A ? 80 89 B ? 51 79 C ? 41 50 D ? 0 40 F ?
3 Replies

# Re: Q. count if doubt

=SUMPRODUCT((\$B\$2:\$B\$51>=D2)*(\$B\$2:\$B\$51<=E2))

Maybe with this formula as shown in the attached file.

thankyou

# Re: Q. count if doubt

Alternatively: The formula in G2 is

``=COUNTIFS(\$B\$2:\$B\$51,">="&D2,\$B\$2:\$B\$51,"<="&E2)``

This can be filled down.