SUM
Name
Summation
Description
Sums cells or blocks.
Syntax
SUM(value1, value2, . . . )
Remarks
Accepts up to 30 arguments. Each argument can be a cell, a cell range, a float value, or an integer value.
Data Type
Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
SUM(R1C2,R3C5,R6C2,R1C7)
SUM(A1,B7,C11)
SUM(A1:A9)
SUM(95,89,73,87,85,76,100,96,96)=797