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

Glossary Item Box

SUMSQ


Name

Sum of the squares

Description

Returns the sum of the squares of the arguments.

Syntax

SUMSQ(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 SUM.

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

SUMSQ(R1C2,R3C5,R6C2,R1C7)
SUMSQ(A1,B7,C11)
SUMSQ(A1:A9)
SUMSQ(95,89,73,87,85,76,100,96,96)=71277

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