Adds a series of numbers.
Sample Usage
SUM(Cost1:Cost5)
Syntax
SUM(
-
number1
-
[
]
- number2
- ...
-
number1—The number or range of numbers to add.
-
—[optional]
- number2
- ...
Additional numbers or ranges of numbers to add.
Examples
This example references the following sheet information:
| Clothing Item | Transaction Total | Units Sold | Price Per Unit | |
|---|---|---|---|---|
| 1 |  Totals |
4,285.00 | 337 | 250.00 |
| 2 | T-Shirt | 1,170.00 | 78 | 15.00 |
| 3 | Pants | 1,491.00 | 42 | 35.50 |
| 4 | Jacket | 812.00 | 217 | 200.00 |
Given the table above, here are some examples of using SUM in a sheet:
| Formula | Description | Result |
|---|---|---|
| =SUM(12, 45, 72) | Sums a series of numbers: 12, 45, and 72. | 129 |
| =SUM([Transaction Total]:[Transaction Total]) | Sums the “Transaction Total” column. | 8,570.00 |
| =SUM(CHILDREN()) | Placed in the parent row to sum the child rows of the “Transaction Total” column. Rows 2 through 4 apply. (Row 1 is the parent row.) | 4,285.00 |
| =IF(SUM([Transaction Total]4)= ([Units Sold]4 * [Price Per Unit]4), "Total Correct" , "Total Incorrect") | Returns the string “Total correct” if the value of the “Transaction Total” on row 4 is equal to “Units Sold” on row 4 times “Price Per Unit” on row 4. Returns “Total Incorrect” otherwise. | Total Incorrect |