Frequency Circular Reference - Again!!
 

I posted a message a few hours ago regarding my problem with a frequency
formula I was trying to use with students' grades on a spread sheet. Biff
answered and solved my problem. I did what he suggested and it worked!! (A
copy of my problem and Biff's response is below this paragraph.) Then I hit
a key by mistake and the whole thing got screwed up. So, armed with Biff's
solution, I entered the same information Biff suggested, in the exact cell
cells and rows, but now it does not work! I am totally flumoxed since it
worked 5 minutes ago. Anyway, if Biff is out there, or anyone else with a
solution, I'd sure appreciate the help. Here's the messaging:

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

--
Thanks very much!!
Barrie

Just a guess ..

if you used
=FREQUENCY(B50:B60,C50:C57)

did you enter it with
key combo of CTRL,SHIFT,ENTER
(instead of just pressing ENTER)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"barrie" wrote in message
...
I posted a message a few hours ago regarding my problem with a frequency
formula I was trying to use with students' grades on a spread sheet. Biff
answered and solved my problem. I did what he suggested and it worked!!
(A
copy of my problem and Biff's response is below this paragraph.) Then I
hit
a key by mistake and the whole thing got screwed up. So, armed with
Biff's
solution, I entered the same information Biff suggested, in the exact cell
cells and rows, but now it does not work! I am totally flumoxed since it
worked 5 minutes ago. Anyway, if Biff is out there, or anyone else with a
solution, I'd sure appreciate the help. Here's the messaging:

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


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
.

--
Thanks very much!!
Barrie