How to use the Excel SUM Function
Is Draft
November 20, 2018
Description
The Excel SUM function is used to add individual cells, cell references, ranges or a mixture of the 3
Usage 1
=SUM(number1, [number2 ... number255])Parameters
| Name | Required | Description |
|---|---|---|
| number1 | Yes | details |
| number2 … number225 | No | details |
Examples
=SUM(10, 20, 30)
=SUM(A1, A2)
=SUM(10, A1, A2)Usage 2
=SUM(range1, [range2], ...)Parameters
| Name | Required | Description |
|---|---|---|
| range1 | Yes | details |
| range2, range3, etc | No | details |
Examples
=SUM(A:A)
=SUM(A1:A50)
=SUM(A:A, B:B)Usage 3
=SUM(number1|range1, [number2|range2], ...)Parameters
| Name | Required | Description |
|---|---|---|
| number1 OR range1 | Yes | details |
| number2, number3, etc OR range2, range3, etc | No | details |
Examples
=SUM(100, A:A)
=SUM(50, A1:A50, B2)
Official Article
Microsoft Excel SUM Function