Frequency Array formula EXCEL not calculating
<p>Hi I am having problems with the Frequency function in excel. This example is from the CTR SHIFT ENTER book and in it is an example, data below. In cell E5 to E10 the solution gives an array formula - <code>{=FREQUENCY(A5:A17,C5:C9)}</code>which calculates the results see below</p>

<p>DATA</p>

<pre><code>(sec)       Upper Limits
65.52       40.00
52.10       45.00
46.50       50.00
39.40       55.00
43.50       60.00
46.80       
47.80       
48.10       
48.00       .
43.50       
52.30       
56.35       
41.85   
</code></pre>

<p>RESULTS already on sheet</p>

<pre><code>Frequency
1
3
5
2
1
1
</code></pre>

<p>My problem is I am copying the formula EXACTLY as above and pressing CSE into the cells H5:H10 but my results are all coming back as 1 which seems to be only counting the lowest limit in my bin_array. I have checked and the formulas match all the way down.</p>