﻿ SUM function

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, SharePoint Server 2007

﻿