Frequency Values Don't Appear in Cells Below

%3CLINGO-SUB%20id%3D%22lingo-sub-1897647%22%20slang%3D%22en-US%22%3EFrequency%20Values%20Don't%20Appear%20in%20Cells%20Below%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1897647%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20a%20novice%20Excel%20user%2C%20so%20a%20little%20help%20would%20be%20very%20much%20appreciated.%20I'm%20just%20trying%20to%20calculate%20frequency%20under%20column%20D.%20My%20problem%20is%20that%20when%20I%20type%20the%20formula%20the%20only%20value%20that%20appears%20is%20in%20cell%20D2%20with%20no%20values%20in%20the%20subsequent%20cells%20below%20in%20the%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20sure%20it's%20not%20a%20big%20fix%2C%20but%20if%20anyone%20could%20point%20me%20in%20the%20right%20direction%2C%20I'd%20be%20thankful.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%3A%20I%20have%20tried%20dragging%20the%20cell%20down%2C%20but%20it%20gives%20me%20cumulative%20frequency%20value%20instead%20of%20the%20values%20for%20each%20of%20the%20bins.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Frequency%201.PNG%22%20style%3D%22width%3A%20453px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F234220i2582567D7D2A991A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Frequency%201.PNG%22%20alt%3D%22Frequency%201.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1897647%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1897724%22%20slang%3D%22en-US%22%3ERe%3A%20Frequency%20Values%20Don't%20Appear%20in%20Cells%20Below%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1897724%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F872360%22%20target%3D%22_blank%22%3E%40bsong416%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EConfirm%20the%20formula%20with%20Ctrl%2BEnter%20to%20enter%20it%20in%20all%20cells%20of%20the%20selection.%3C%2FP%3E%0A%3CP%3EBy%20the%20way%2C%20I'd%20use%20%3DFREQUENCY(A2%3AA21%2CC2%3AC9)%20since%20your%20bins%20are%20in%20C2%3AC9.%3C%2FP%3E%0A%3CP%3EIf%20you%20have%20ages%20over%2010%2C%20select%20D2%3AD10%2C%20enter%20the%20same%20formula%20and%20confirm%20with%20Ctrl%2BEnter.%20D10%20will%20contain%20the%20count%20of%20ages%20over%2010.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1897769%22%20slang%3D%22en-US%22%3ERe%3A%20Frequency%20Values%20Don't%20Appear%20in%20Cells%20Below%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1897769%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%20appreciate%20the%20help!%20Was%20excited%20to%20try%20this%20out%20but%20it's%20only%20fixed%20the%20issue%20halfway.%20I'm%20getting%20values%20to%20appear%2C%20but%20the%20values%20are%20incorrect.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20values%20under%20the%20frequency%20column%20should%20be%20%7B0%2C%203%2C%203%2C%204%2C%203%2C%204%2C%203%2C%200%7D%20respectively.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20any%20other%20suggestions%2C%20I'd%20be%20happy%20to%20test%20them%20out!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20gain!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Frequency%202.PNG%22%20style%3D%22width%3A%20461px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F234232i06B4A92C61DEE7DA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Frequency%202.PNG%22%20alt%3D%22Frequency%202.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1897829%22%20slang%3D%22en-US%22%3ERE%3A%20Frequency%20Values%20Don't%20Appear%20in%20Cells%20Below%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1897829%22%20slang%3D%22en-US%22%3EI'm%20sorry%2C%20I%20meant%20Ctrl%2BShift%2BEnter%20instead%20of%20Ctrl%2BEnter.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi there,

 

I'm a novice Excel user, so a little help would be very much appreciated. I'm just trying to calculate frequency under column D. My problem is that when I type the formula the only value that appears is in cell D2 with no values in the subsequent cells below in the column.

 

I'm sure it's not a big fix, but if anyone could point me in the right direction, I'd be thankful.

 

Note: I have tried dragging the cell down, but it gives me cumulative frequency value instead of the values for each of the bins. 

 

Frequency 1.PNG

3 Replies
Highlighted

@bsong416 

Confirm the formula with Ctrl+Enter to enter it in all cells of the selection.

By the way, I'd use =FREQUENCY(A2:A21,C2:C9) since your bins are in C2:C9.

If you have ages over 10, select D2:D10, enter the same formula and confirm with Ctrl+Enter. D10 will contain the count of ages over 10.

Highlighted

@Hans Vogelaar  appreciate the help! Was excited to try this out but it's only fixed the issue halfway. I'm getting values to appear, but the values are incorrect. 

 

The values under the frequency column should be {0, 3, 3, 4, 3, 4, 3, 0} respectively.

 

If you have any other suggestions, I'd be happy to test them out!

 

Thanks gain!

 

Frequency 2.PNG

Highlighted
I'm sorry, I meant Ctrl+Shift+Enter instead of Ctrl+Enter.