Formualizer Docs
ReferenceFunctionsMath Functions

SUMX2MY2

SUMX2MY2: Returns the sum of squares of values in one array minus the squares in another.

Summary

Returns the sum of squares of values in one array minus the squares in another.

Examples

Pairwise squared difference of squares
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-4

FAQ

What happens when the arrays have different sizes?

SUMX2MY2 returns #N/A when the two inputs do not contain the same number of values.

Runtime metadata

Category

Math

Signature

SUMX2MY2(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

SUMSQ

SUMSQ: Returns the sum of squares of supplied numbers.

SUMX2PY2

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

On this page

SummaryExamplesRelated functionsFAQWhat happens when the arrays have different sizes?Runtime metadata