Q. count if doubt

[Danny03]

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	?

[#2]

@Danny03 

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

Maybe with this formula as shown in the attached file.

[#3]

thankyou

[#4]

@Danny03 

Alternatively:

The formula in G2 is

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

This can be filled down.