ReferenceFunctionsMath Functions

SUMXMY2

SUMXMY2: Returns the sum of squared differences between corresponding values.

Summary

Returns the sum of squared differences between corresponding values.

Examples

Pairwise squared differences

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

2

FAQ

What shape must the inputs have?

Both inputs must flatten to the same number of values or the function returns #N/A.

Runtime metadata

Category

Math

Signature

SUMXMY2(arg1, arg2, ... argN: Number (Range))

This function accepts a repeating argument pattern (min args: 2).

Arity

min 2, max 1

Arguments

arg1

Number · Range · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/math/numeric.rs

SUMX2PY2

SUMX2PY2: Returns the sum of squares of corresponding values from two arrays.

TAN

Returns the tangent of an angle in radians.

On this page

Summary Examples Related functions FAQ What shape must the inputs have?Runtime metadata