Frequency Array Function

  • Thread starter Thread starter Raeven
  • Start date Start date
R

Raeven

I am trying to figure out how to use the frequency array function. I
have a book that shows the following table:

A | B | C
20 | 20 | 6
83 | 40 | 2
32 | 60 | 3
5 | 80 | 1
15 | 100 | 3
83
4
52
27
10
68
42
43
18
96

Column A and B are constants. The column C contains the frequency
array formula. It shows that cell C1 contains the following:
{=FREQUENCY(A1:A15,C1:C15)}

It says that the results in the column C should mean that there are 6
values in column A that are equal to or less than 20, there are 2
values in column A that are more than 20 but equal to or less than 40,
etc. I do not get these results, even though I entered the array
formula correctly in each row. What am I doing wrong?

Stephanie
 
Stephanie - Highlight cells C1:C5. Enter the formula:

=FREQUENCY(A1:A15,B1:B5)

then hit Ctrl+Shift+Enter instead of just the Enter key.
It is important to have all the cells you want the formula
in highlighted when you type or change the formula.

HTH
Erin
 
Thank you so much. You know, it always seems that there is a step o
two to array functions that the books leave out or assume you know.
I'm having to write notes in mine.

Thanks again,
Stephani
 
Back
Top