problem with FREQUENCY

i would like to enter the array formula for frequency in cells B34:F34
(ROW 34) as follows:

{=FREQUENCY(B5:Q5,B32:F32)}

however, i get a bunch of zeros. if, however, i enter the formula in a
single COLUMN, such as B34:B38, i get the correct answer.

so my question is, can array formulas be entered only in a
"column-wise"? if not, what am i doing wrong?

gautam.

Try:

=TRANSPOSE(FREQUENCY(B5:Q5,B32:F32))

(still array entered)

Select the cell with your formula and hit F9.

You'll see something like:
={3;4;3;4;2;0}

You'll see commas if you do the same with the =transpose(frequency()) version:
={3,4,3,4,2,0}

Those semicolons mean that you get a vertical list.

Another hint is in Excel's help for =frequency()

Calculates how often values occur within a range of values, and then returns a
vertical array of numbers....

<vbg>




Gautam wrote:
>
> i would like to enter the array formula for frequency in cells B34:F34
> (ROW 34) as follows:
>
> {=FREQUENCY(B5:Q5,B32:F32)}
>
> however, i get a bunch of zeros. if, however, i enter the formula in a
> single COLUMN, such as B34:B38, i get the correct answer.
>
> so my question is, can array formulas be entered only in a
> "column-wise"? if not, what am i doing wrong?
>
> gautam.

--

Dave Peterson