Sumproduct formula

Topics: Developer Forum
Apr 26, 2011 at 1:54 PM

Been trying to figure this out for last couple of hours.

I have this formula

$total->setCellValue('C3', '=SUMPRODUCT(MOD(ROW(C4:C5),2)*C4:C5)');  

Which creates the excel file fine but creates a #VALUE! in excel.

If I enterthe cell and press RETURN the formula works fine.

I'm using excel5 to render the spreadsheet.



Apr 29, 2011 at 10:07 PM

Are you trying to create an Excel array formula?

May 3, 2011 at 9:15 AM


is there a solution to this problem yet? I have the exact same problem, everytime I use the sumproduct formula in a cell I'll get the #VALUE! error and when I click into a cell and press enter everything works fine - every other formula seems to work fine though.