Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular reference toolbar | Excel Discussion (Misc queries) | |||
Help solve a Circular Reference | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
Circular reference | Excel Discussion (Misc queries) | |||
Circular reference | Excel Worksheet Functions |