formula
 

Hi

I have a list of exam results, in one column. I am trying to count how many
scored in 7 different ranges. I have tried the countif, frequency and sum
if, do not really know what I am doing wrong. I want to know how many
students scored between 0-39, then how many student scored between 40-49 then
how many scored between 50-59 etc. Can anyone help as I am now totally lost!

Thanks

formula
 

Put the limits in say E1:E5, and then enter this block array formula

=FREQUENCY(A1:A10,E1:E5)

that is, select E1:E5, enter the formula in the formula bar, then commit
with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"SA UK" wrote in message
...
Hi

I have a list of exam results, in one column. I am trying to count how
many
scored in 7 different ranges. I have tried the countif, frequency and sum
if, do not really know what I am doing wrong. I want to know how many
students scored between 0-39, then how many student scored between 40-49
then
how many scored between 50-59 etc. Can anyone help as I am now totally
lost!

Thanks

formula
 

Hi Bob Phillips

Thanks for your help.

It worked!

SA

"Bob Phillips" wrote:

Put the limits in say E1:E5, and then enter this block array formula

=FREQUENCY(A1:A10,E1:E5)

that is, select E1:E5, enter the formula in the formula bar, then commit
with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"SA UK" wrote in message
...
Hi

I have a list of exam results, in one column. I am trying to count how
many
scored in 7 different ranges. I have tried the countif, frequency and sum
if, do not really know what I am doing wrong. I want to know how many
students scored between 0-39, then how many student scored between 40-49
then
how many scored between 50-59 etc. Can anyone help as I am now totally
lost!

Thanks