SUMXMY2
Returns the sum of squares of differences of corresponding values in two arrays.
Math & TrigonometryMath Basics
What it does
Calculates sum of (x - y)^2.
Syntax
SUMXMY2(array_x, array_y)
Arguments
array_x(range) — X values.array_y(range) — Y values.
Examples
Square of Diff
Sum((x-y)^2).
FORMULA
=SUMXMY2(A1:A2, B1:B2)
RESULT
2
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | X | Y |
| 2 | 1 | 2 |
| 3 | 3 | 4 |