Hi

I try to use array formula but I get an #VALUE error when I open the workbook. The formula is ok since when I edit the formula in the Excel formula bar, it recalculates correctly.

The formulas I use looks like...

r.SetArrayFormula("=SUM(IF($A$10:$A$13=4,IF($I$10:$I$13<>\"\",IF($F$10:$F$13<>-1,$I$10:$I$13*$D$10:$D$13,0),0),0))*$D9",1,1)

I attached an example. What can i do to solve this problem?

thank you

Alexandre