Frequency Array formula EXCEL not calculating

0 votes

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.

Oct 31, 2022 in Others by Kithuzzz
• 28,520 points
57 views

1 answer to this question.

0 votes
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.
answered Oct 31, 2022 by narikkadan
• 52,760 points

Related Questions In Others

0 votes
0 answers

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

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

Nov 2, 2022 in Others by Kithuzzz
• 28,520 points
48 views
0 votes
1 answer

MS Excel TRUE/FALSE Formula Not Returning Expected Result

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

answered Nov 8, 2022 in Others by gaurav
• 22,940 points
100 views
0 votes
1 answer

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

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

answered Nov 13, 2022 in Others by narikkadan
• 52,760 points
90 views
0 votes
1 answer
0 votes
1 answer

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

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
213 views
0 votes
1 answer

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

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

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
385 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

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

Feb 17, 2022 in Others by Edureka
• 13,630 points
174 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

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

answered Feb 18, 2022 in Others by gaurav
• 22,940 points
160 views
0 votes
1 answer

PHPExcel generated excel file not auto-calculating formula

By recalculating on the server side, it ...READ MORE

answered Nov 25, 2022 in Others by narikkadan
• 52,760 points
205 views
0 votes
1 answer

Moving Average formula in Excel not autofilling in table

You could use AVERAGEIFS to make the ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
• 52,760 points
138 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP