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