#SYNTAX_ERROR when using SUM formula


#1

Hi all,

stupid problem: I need to SUM column F (F5 till F80) to get a result (result Sum in B3). I use =SUM(F5:F80)

Some of the fields in F are empty. This worked fine, but recently I have an issue when adding an extra number in for ex. F22 (which was previously empty).
It should Sum fine, but I get a syntax-error.

The funny part of the problem: when I double click the syntax-error and press enter again (to confirm the SUM formula in the field), it works fine again (until I add another number in F column, same problem).


After enter.

Very frustrating. :smiling_imp:

TECHSPECS: wordpress environment, Chrome 36.0.1985.143 m

Saldo issue is based on the syntax-error so no problem there.

Any idea?

greetz & tnx.


#2

Same problem i am facing …


#3

Could you please, provide a complete demo or a demo link, where the problem can be reconstructed locally.