SumSq

Syntax

SumSq(Values1, …)

Parameters

Values1, Values2, …, ValuesN. The range of cells, for which you want the sum of squares.

Description

It returns the sum of squared arguments in the defined cell range.

Example

Formula Result Description
=SumSq(B6:E6) 38 The sum of squares for numbers belonging to the cell range between B6 and E6. This range contains the following numbers: 3; 4; 3,6; -0,2.

See also:

Function Wizard | Mathematical Functions | Sum | SumX2MY2 | SumX2PY2 | SumXMY2