One problem you have is that your boudaries overlap:

0 50 F
50 52 D-
52 56 D
56 59 D+

Is a score of 50 a F or a D- ?

--
Biff
Microsoft Excel MVP


"Jym" wrote in message
...

Hi and thank you for your time.

I have the following data in a spread sheet

A B C
0 50 F
50 52 D-
52 56 D
56 59 D+ //this continues through A+ it's our schools marking
system.

On another sheet in the same workbook I have my 300 students listed
with their grade inputted as well.

LastName FirstName Grade
Smith John 65

---------------------
What I would like to do is find out the frequency of grades on another
sheet that might look like

Grade Frequency
A 12 // where 12 means that 12 students recieved a mark
between 85 and 89

TIA




--
Jym