A space is a charater just like "a", "b", "c".
="a"+"b" raises an error because + is an arithmetic operator which applies to numbers only. Even ="1"+"2" raises an error because you can not add character "1" to character "2".

So your =e1+f1 fails whenever you refer to a text value.
Try =SUM(E1;F1)
Contrary to arithmetic operators, many arithmetic functions can ignore text.


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to