Forum Discussion
Frequency Values Don't Appear in Cells Below
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 valu...
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.
HansVogelaar 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!
