Adds a series of numbers.
Sample Usage
SUM(Cost1:Cost5)
Syntax
SUM(

number1

[
 number2
 ...

number1—The number or range of numbers to add.

 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  TShirt  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 