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