Frequency displays incorrect

[Willem]

I am using the Frequency function. I am using the sampple in the Ecel help
files and I am entering the erray formula correctly and the function wizard
box does show the answer correctly but the cell in the workbook displays 0.

FREQUENCY(A1:A9,C4:C6) equals {0;2;5;2}

But I get 0

Please help

 

[A.W.J. Ales]

Willem,

It looks as if you selected only one cell and therefore you only get 1
answer ( i.e. 0).

You should select 4 cells (in your example in 1 column) and THEN array enter
the formula.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *