Q. count if doubt

Occasional Contributor

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

 

StudentGrades
Student 162
Student 292
Student 352
Student 460
Student 581
Student 666
Student 763
Student 8100
Student 946
Student 1087
Student 1193
Student 1284
Student 1344
Student 1471
Student 15100
Student 1640
Student 1735
Student 1873
Student 1999
Student 2088
Student 2190
Student 2290
Student 2344
Student 2474
Student 2546
Student 2674
Student 2792
Student 2831
Student 2951
Student 3059
Student 3185
Student 3263
Student 3360
Student 3483
Student 3572
Student 3694
Student 3792
Student 3892
Student 3959
Student 4051
Student 4145
Student 4289
Student 4351
Student 4484
Student 4532
Student 4673
Student 4744
Student 4881
Student 4976
Student 5089

 

MinMaxGradeFrequency
90100A?
8089B?
5179C?
4150D?
040F?
    
3 Replies

@Danny03 

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

 

Maybe with this formula as shown in the attached file.

thankyou

@Danny03 

Alternatively:

S1092.png

The formula in G2 is

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

This can be filled down.