How to add / sum of numbers in OpenOffice Spreadsheet?
The syntax of sum function is =SUM(number1; number2; ... number30).
There are two options to add two or more numbers,
Option 1:
Step 1: First click on the cell where you want the answer to be displayed.
Step 2: Type = then select the cell reference followed by a plus sign and then click on the next cell reference.
Step 3: Press "Enter" key.
Example 1: If you want to add the value "343" which is in cell A3 and "353" which is in cell A6, then you have to give it as
=(A3+A6)
Option 2:
Step 1: Click on the cell where you want the answer to be displayed.
Step 2: Type "=SUM(" then select the cells separated by semicolon and close the bracket.
Step 3: Press the Enter Key on the Keyboard.
Example 2: If you want to add the value "343" which is in cell A3 and "353" which is in the cell A5, then you have to give it as
=Sum(A3;A5)