frequency

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to find the freqency for C2:C62. the bins are 49.99,
59.99,69.99,79.99,100 in G7...G11
I did this: =FREQUENCY(C2:C62,G7:G11) the answer for the first bin is
right, but it repeates it for all the other bins. what formula should I put
in H8,h9,h10 and h11?
leslie
the date works now. cell not formated to general
 
leslie said:
I am trying to find the freqency for C2:C62. the bins are 49.99,
59.99,69.99,79.99,100 in G7...G11
I did this: =FREQUENCY(C2:C62,G7:G11) the answer for the first bin is
right, but it repeates it for all the other bins. what formula should I
put
in H8,h9,h10 and h11?
Click to expand...

FREQUENCY is one of the few functions that always returns an array. You need
to enter the formula as an array formula. Select H7:H12 (yes, H12, since
FREQUENCY returns one more value than the number of bins), type the formula
then hold down [Ctrl] and [Shift] keys before pressing [Enter].
 
Select the range (H8:H11)
enter the formula =FREQUENCY(C2:C62,G7:G11)
and now FOR THE TRICKY bit: do NOT press enter or the green check make but
hold down SHIFT and CONTROL and then tap the ENTER key
This is an array formula; with the SHIFT+CTRL+ENTER, Excel will make the
formula display in Formula Bar as {=FREQUENCY(C2:C62,G7:G11)}
You do not type the braces {} but Excel adds them
See http://www.cpearson.com/excel/array.htm for more details
best wishes
 
Back
Top