Spread 8.0 Documentation
SUM
Support Options
Formula Reference > Built-In Functions > SUM

Glossary Item Box

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.

See also ADD and SUMSQ.

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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.