SUM function

Adds all the numbers in the specified arguments.

Syntax

SUM(number1,number2,...)

Number1, number2,...     are 1 to 30 arguments for which you want the total value or sum.

Remarks

  • Numbers, logical values, and text representations of numbers that you type directly into the list of arguments are counted. See the first and second examples following.
  • Arguments cause errors if they are error values or text that cannot be translated into numbers.

Examples

Col1 Col2 Col3 Col4 Col5 Formula Description (Result)
-5 15 30   TRUE =SUM(3, 2) Adds 3 and 2 (5)
-5 15 30   TRUE =SUM("5", 15, TRUE) Adds 5, 15 and 1, because the text values are translated into numbers, and the logical value TRUE is translated into the number 1 (21)
-5 15 30   TRUE =SUM([Col1], [Col2], [Col3]) Adds the first three numbers in the columns (40)
-5 15 30   TRUE =SUM([Col1], [Col2], [Col3], 15) Adds the first three numbers in the columns, and 15 (55)
-5 15 30   TRUE =SUM([Col4], [Col5], 2) Adds the values in the last two columns and 2 (3)
 
 
Applies to:
SharePoint Server 2007, Windows SharePoint Services 3.0, Deployment Center 2003