Frequency Function

[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
....

 

[Gord Dibben]

Select D26 and enter the formula in D2

CTRL + SHIFT + ENTER to fill D26

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

 

[Ken Johnson]

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

 

[exalan]

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

 

[Aladin Akyurek]

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.