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.

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

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

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

**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 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 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 in the formula bar, to display the answer.

**Also Read:**- What Is Microsoft Excel Formula
- Fix | Workbook Is Opened In Compatibility Mode In 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
- Minimizing The Ribbon Of Excel 2016
- Creating and Opening Workbooks | Excel 2016 Video

**Team Pinfoltd**
## 0 comments: