Create Array Formula Fail.

Aug 22, 2014 at 6:30 AM
I try to create an array formula , but it doesn't work, only first cell show the value, others are empty.

code:
worksheet.Cells["E2:E5"].CreateArrayFormula("FREQUENCY(B2:B18,C2:C5)");
Excel:
Image

you can see that Cells["E3:E5"] has array formula but empty.
Help~~~
Jun 15, 2016 at 6:53 AM
I got this issue, the same case, please help me