SUM(CELL;CELL) does not work

Topics: Developer Forum
Nov 17, 2008 at 9:16 AM
Edited Nov 17, 2008 at 9:18 AM

I can't make the formula SUM(CELL;CELL) work. If I set the setPreCalculateFormulas to false then excel tells me there is an error in the file and after he fixed it the value is 0.

If the setPreCalculateFormulas is set to false then the browser tells me he can't find the files.

In the mean time I use =CELL+CELL+CELL+CELL wich works good.

Nov 17, 2008 at 10:03 AM
Formula must be written like in English version of Excel using comma to separate function arguments.

Check this post:
Nov 17, 2008 at 10:38 AM
Okay I see.

It works now :).