Manuals/calci/SUMXMY2
SUMXMY2(ArrayX, ArrayY)
where,
ArrayX - represents the first array of values.
ArrayY - represents the second array of values.
It returns the sum of differences of corresponding values in two arrays.
Formula :-
SUMXMY2 = Σ (x - y )2
If ArrayX and ArrayY have different number of values, SUMXMY2 returns the #ERROR.
SUMXMY2
Lets see an example in (Column3, Row1)
=SUMXMY2(R1C1:R7C1,R1C2: R7C2)
SUMXMY2 returns 259.
Consider an another example
=SUMXMY2(R1C1:R7C1,R1C2: R6C2)
SUMXMY2 returns the #ERROR.
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 15 | 1 | 259 | |
| Row2 | 8 | 2 | ||
| Row3 | 5 | 3 | ||
| Row4 | 1 | 4 | ||
| Row5 | 8 | 5 | ||
| Row6 | 7 | 6 | ||
| Row7 | 5 | 7 |
