Formualizer Docs
ReferenceFunctionsMath Functions

SUMX2PY2

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

Summary

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

Examples

Pairwise squared sums
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
30

FAQ

Does SUMX2PY2 coerce booleans and blanks?

It follows the same collection rules as the engine's paired-array helpers, coercing booleans and treating blanks/text as zero.

Runtime metadata

Category

Math

Signature

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

SUMX2MY2

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

SUMXMY2

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

On this page

SummaryExamplesRelated functionsFAQDoes SUMX2PY2 coerce booleans and blanks?Runtime metadata