View Single Post
  #1   Report Post  
Jym Jym is offline
Junior Member
 
Posts: 2
Default Frequency and If with multiple Columns

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