SUMSQ

Syntax:

SUMSQ(list)

The SUMSQ function returns the sum of the squares of all the values in the list, which may be an array, a range of cells, or a comma-separated list of values.

The equation used is:

Σi=n xi2

where xi is each value and n is the number of values.

Example:

SUMSQ(B1:B14)

returns the sum of the squares of the values of cells B1 to B14.

Added in 2.00.