Frequency Array Function

[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

 

[Erin Kotch]

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

 

[Raeven]

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