SUM Function

Adds a series of numbers.
Sample Usage
SUM(Cost1:Cost5)
Syntax
SUM(
  • number1
  • [
    • number2
    • ...
    ]
)
  • number1
    The number or range of numbers to add.
    • number2
    • ...
    —[optional]
    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 button parent row expanded 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