Frequency Function

  • Thread starter Thread starter MzJuanita
  • Start date Start date
M

MzJuanita

When i enter =FREQUENCY(A2:A81,C2:C6) into cell C2 i'm not getting an array
of answers. I only get the one answer (35). What am i doing wrong

Data BINS Frequency
76 70 35
72 85
88 100
60 115
72 130
68
80
64
....
 
Select D2:D6 and enter the formula in D2

CTRL + SHIFT + ENTER to fill D2:D6

Help on the FRQUENCY function explains that it is an Array Formula and must be
entered as such.

If you do it right, you will get curly brackets like so

{=FREQUENCY(A2:A81,C2:C6)}


Gord Dibben MS Excel MVP
 
When i enter =FREQUENCY(A2:A81,C2:C6) into cell C2 i'm not getting an array
of answers. I only get the one answer (35). What am i doing wrong

Data BINS Frequency
76 70 35
72 85
88 100
60 115
72 130
68
80
64
...

Select C2:C7, click in the formula bar then type
=FREQUENCY(A2:A81,B2:B6), then hold down Ctrl + Shift while you press
Enter.

I have assumed data in A2:A81, Bins in B2:B6 and you want Frequencies
in column C.

Ken Johnson
 
Assuming your data array is in column A and bin array in column C, highlight
D2 to D6, type your frequency formula, then press Shift+Ctrl+Enter, you shud
get the desired results
 
If you can bear calling two more functions, just enter in...

C2:

=INDEX(FREQUENCY($A$2:$A$81,$C$2:$C$6),ROWS($C$2:C2))

....and copy down.
 
Back
Top