Frequency and If with multiple Columns

[Jym]

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 markin
system.

On another sheet in the same workbook I have my 300 students liste
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 anothe
sheet that might look like

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

TI

 

[pdberger]

Jym --

It sounds like you are trying to create a histogram, or at least the data to
support one. Excel has a histogram method. If you've already installed it,
it will be under >Tools>Data Analysis. If you haven't installed the data
analysis tools it won't be there, but it's easy to install. Just go to

Tools>Addins, and click on 'Data Analysis' tools. (Don't click the 'Data

Analysis - VBA', that's used for programming...). Then the histogram is
available. You'll be able to make the table and/or chart, depending on what
options you select.

HTH

 

[T. Valko]

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- ?