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

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

Oct 31, 2022 in Others 310 views

## 1 answer to this question.

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.
• 63,700 points

## Why is Excel not calculating the cube root as the cube root?

I think Excel treats exponents with recurring ...READ MORE

## MS Excel TRUE/FALSE Formula Not Returning Expected Result

The reason for this is that the 'words' ...READ MORE

## Text with a dash in the cell but not in the formula bar (Excel)

What you have got here is called ...READ MORE

## Excel is not updating cells, options > formula > workbook calculation set to automatic

This occurred to me today in a ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE