The SUM formula is used when you want to add up two or more numbers together in Excel. It can also be used to add up the numeric content of two or more cells in your worksheet, or to add up the numeric content of a range of cell in your worksheet.

**Using The SUM Formula To Add Numbers**

To use the SUM formula to add up numbers, all you need to do is to

- Select the cell you want the answer to be displayed.
- Type in SUM preceded by the equal to sign, then followed by parenthesis.

That is**=SUM()**. - In the parenthesis, insert/type in the numbers you want to add up, separated by comma.

Example:**=SUM(10, 5, 5)**. - And hit the
**Enter**key in your keyboard or**Accept**button in the formula bar.

**Using The SUM Formula To Add Up Multiple Cells**

To add up cells using the SUM formula, all you need to do is to

- Select the cell you want the answer to be displayed.
- Type in SUM preceded by the equal to sign, then followed by parenthesis.

That is**=SUM()**. - In the parenthesis, type in the cell addresses of the cells you want to add up, but separate each cell address with comma.

Example: =**SUM(A2, B4, C1)**. - And then hit the
**Enter**key in your keyboard or the**Accept**button in the formula bar, to display the answer.

**Using The SUM Formula To Add Up Range Of Cells**

To add up a range of cell using the SUM formula, do the following

- Select the cell you want the answer to be displayed.
- Type in SUM preceded by the equal to sign, then followed by a parenthesis.

That is**=SUM()**. - In the parenthesis, type in the cell address of the first cell and the last cell in the range and you want to add up, but separate the two cell address with a
**Column**sign.

Example:**=SUM(A1:A3)**. - Finally, hit the
**Enter**key in your keyboard, or the**Accept**button in the formula bar, to display the answer.

**Also Read:**

- Inserting New Cell(s) In LibreOffice Spreadsheet V5.2.3
- Fix | Workbook Is Opened In Compatibility Mode In Microsoft Excel 2016
- Hide And Unhide Row or Columns | LibreOffice Calc Spreadsheet V5.2
- Using The SUM Formula | Microsoft Excel 2016
- How To Automatically Count The Number Of Times A Number (Numeric Data) or Word (Text Data) Appear In Your Worksheet | Microsoft Excel 2016

**Team Pinfoltd**
## 0 comments: