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

Frequency and If with multiple Columns
 

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 ToolsData Analysis. If you haven't installed the data
analysis tools it won't be there, but it's easy to install. Just go to
ToolsAddins, 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

"Jym" wrote:


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

Frequency and If with multiple Columns
 

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

Actually it's "<" the right column and "=" the left column so 49.9 is an F and 50 is a D-