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: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org