Hello, I'm having issues with Excel's Frequency function. The information in this example is taken from the CTR SHIFT ENTER book. The array formula =FREQUENCY(A5:A17,C5:C9) in cells E5 to E10 of the solution calculates the results. see below:

DATA

(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

RESULTS already on sheet

Frequency
1
3
5
2
1
1

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.