Documentation/How Tos/Calc: SUMX2PY2 function

SUMX2PY2

Returns the sum of the squares of all elements of two matrices.

Syntax:

SUMX2PY2(x; y)

x and y are arrays or ranges of the same size. SUMX2PY2 calculates for the i elements in the arrays. It evaluates in array mode, but does not need to be entered as an array formula.

Example:

SUMX2PY2(A1:A2; {2|1})

where cells A1 and A2 contain 4 and 3 respectively, returns (4²+2²) + (3²+1²) = 30.

See also:

SUM, SUMIF, SUMSQ, SUMPRODUCT,SUMX2MY2, SUMXMY2

Conditional Counting and Summation

How To Use Arrays in Calc

Array functions