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 in Others by Kithuzzz
• 20,660 points
31 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 by narikkadan
• 37,660 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 in Others by Kithuzzz
• 20,660 points
32 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 in Others by gaurav
• 22,040 points
67 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 in Others by narikkadan
• 37,660 points
30 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 in Others by Edureka
• 13,640 points
142 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 in Others by Edureka
• 13,640 points
242 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 in Others by Edureka
• 13,640 points
109 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

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

answered Feb 18 in Others by gaurav
• 22,040 points
71 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 in Others by narikkadan
• 37,660 points
31 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 in Others by narikkadan
• 37,660 points
67 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