Sumproduct formula

Topics: Developer Forum
Apr 26, 2011 at 12: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.

Thanks,

Lee

Coordinator
Apr 29, 2011 at 9:07 PM

Are you trying to create an Excel array formula?

May 3, 2011 at 8:15 AM

Hi,

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.

Thanks,

Simon