I am a professor and have a spread sheet containing student grades. I am
trying to use the frequency function so that I can then create a chart
showing how many grades occured within certain grade ranges. I've got column
B with the students' grades (B50:B60) and column C with the bins (C50:C58)
using score ranges 30, 40, 50 etc. Whenever I finish entering the array
formulas from a cell in column D, a box appears that I have a circular
reference and it assigns a value of 0. I've followed all the instructions
for trying to fix it, and I've read the knowledge base articles. But I am
not a computer science professor and cannot understand what I've done wrong
or how to fix it. Can anyone please help me? Here are my columns B and C:

B
60.72
41.4
56.58
71.76
45.54
73.14
37.26
73.14
80.04
60.72
55.2

C
30
40
50
60
70
80
90
100

--
Thanks very much!!
Barrie

Hi!

With the grades in the range B50:B60, the "bins" in the
range C50:C57

Select the range D49:D57.

Type this formula in the Formula Bar and enter it with the
key combo of CTRL,SHIFT,ENTER:

=FREQUENCY(B50:B60,C50:C57)

An alternative to using an array. In D50 enter this
formula and copy down to D57:

=SUMPRODUCT(--(B$50:B$60=C50),--(B$50:B$60<=C50+10))

Biff

-----Original Message-----
I am a professor and have a spread sheet containing
student grades. I am
trying to use the frequency function so that I can then
create a chart
showing how many grades occured within certain grade
ranges. I've got column
B with the students' grades (B50:B60) and column C with
the bins (C50:C58)
using score ranges 30, 40, 50 etc. Whenever I finish
entering the array
formulas from a cell in column D, a box appears that I
have a circular
reference and it assigns a value of 0. I've followed all
the instructions
for trying to fix it, and I've read the knowledge base
articles. But I am
not a computer science professor and cannot understand
what I've done wrong
or how to fix it. Can anyone please help me? Here are
my columns B and C:

B
60.72
41.4
56.58
71.76
45.54
73.14
37.26
73.14
80.04
60.72
55.2

C
30
40
50
60
70
80
90
100

--
Thanks very much!!
Barrie
.

Slight correction:

=SUMPRODUCT(--(B$50:B$60=C50),--(B$50:B$60<=C50+10))

Should be:

=SUMPRODUCT(--(B$50:B$60=C50),--(B$50:B$60<C50+10))

Biff

-----Original Message-----
Hi!

With the grades in the range B50:B60, the "bins" in the
range C50:C57

Select the range D49:D57.

Type this formula in the Formula Bar and enter it with
the
key combo of CTRL,SHIFT,ENTER:

=FREQUENCY(B50:B60,C50:C57)

An alternative to using an array. In D50 enter this
formula and copy down to D57:

=SUMPRODUCT(--(B$50:B$60=C50),--(B$50:B$60<=C50+10))

Biff

-----Original Message-----
I am a professor and have a spread sheet containing
student grades. I am
trying to use the frequency function so that I can then
create a chart
showing how many grades occured within certain grade
ranges. I've got column
B with the students' grades (B50:B60) and column C with
the bins (C50:C58)
using score ranges 30, 40, 50 etc. Whenever I finish
entering the array
formulas from a cell in column D, a box appears that I
have a circular
reference and it assigns a value of 0. I've followed
all
the instructions
for trying to fix it, and I've read the knowledge base
articles. But I am
not a computer science professor and cannot understand
what I've done wrong
or how to fix it. Can anyone please help me? Here are
my columns B and C:

B
60.72
41.4
56.58
71.76
45.54
73.14
37.26
73.14
80.04
60.72
55.2

C
30
40
50
60
70
80
90
100

--
Thanks very much!!
Barrie
.

.

Hey Biff! So far, so good! Thanks for the help. I may be back for more
assistance when I hit the wall trying to chart it. But this was great!!

"Biff" wrote:

Slight correction:

=SUMPRODUCT(--(B$50:B$60=C50),--(B$50:B$60<=C50+10))

Should be:

=SUMPRODUCT(--(B$50:B$60=C50),--(B$50:B$60<C50+10))

Biff

-----Original Message-----
Hi!

With the grades in the range B50:B60, the "bins" in the
range C50:C57

Select the range D49:D57.

Type this formula in the Formula Bar and enter it with
the
key combo of CTRL,SHIFT,ENTER:

=FREQUENCY(B50:B60,C50:C57)

An alternative to using an array. In D50 enter this
formula and copy down to D57:

=SUMPRODUCT(--(B$50:B$60=C50),--(B$50:B$60<=C50+10))

Biff

-----Original Message-----
I am a professor and have a spread sheet containing
student grades. I am
trying to use the frequency function so that I can then
create a chart
showing how many grades occured within certain grade
ranges. I've got column
B with the students' grades (B50:B60) and column C with
the bins (C50:C58)
using score ranges 30, 40, 50 etc. Whenever I finish
entering the array
formulas from a cell in column D, a box appears that I
have a circular
reference and it assigns a value of 0. I've followed
all
the instructions
for trying to fix it, and I've read the knowledge base
articles. But I am
not a computer science professor and cannot understand
what I've done wrong
or how to fix it. Can anyone please help me? Here are
my columns B and C:

B
60.72
41.4
56.58
71.76
45.54
73.14
37.26
73.14
80.04
60.72
55.2

C
30
40
50
60
70
80
90
100

--
Thanks very much!!
Barrie
.

.