Frequency Array formula EXCEL not calculating

Question

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.

Answer 1

You obtain the same outcome, which suggests that FREQUENCY dislikes row inputs (at least, non-adjacent input rows). Once I used (adjacent) columns, it worked fine (of course, the FREQUENCY output needs to be adjacent to the bin data).

I hope this helps you.