Add Numbers using Sum Function

How to add numbers in Google Docs Spreadsheet?

Explanation

There are two options to sum the values.
Option 1: Find the sum using plus sign.
Step 1: Type the cell references with plus sign to sum the values. Here, we find the sum of the cells A3 and A6,

Step 2: Total sum will be displayed in the cell where we used the formula.

Option 2: Use the sum function to find the sum.
Step 1: Type "=sum(", select the cell reference, type ":", select the end range and type ")". Here, we find the sum of the range from A4 and A8,

Step 2: Final result is displayed in the selected cells.

Option 3: Click Insert→Function→SUM.

Using sum function, we can find the sum of different cells instead of range. Just enter the cell reference separated by ",".

Related Topics