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

On Sat, 31 May 2008 15:17:00 -0700, MzJuanita
wrote:

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

On Jun 1, 8:17 am, MzJuanita
wrote:
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
--
exalan


"MzJuanita" wrote:

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

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:C 2))

....and copy down.

MzJuanita wrote:
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
...