SUMX2MY2

SUMX2MY2(array_x, array_y)

Returns the sum of the difference of squares of corresponding values in two arrays.

array_xThe first array or range of values.
array_yThe second array or range of values.

REMARKS
* The arguments should be either numbers or names, arrays, or references that contain numbers.
* If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
* If "array_x" and "array_y" have a different number of values, then #N/A is returned.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=SUMX2MY2({2,3,9,1,8,7,5},{6,5,11,7,5,4,4}) = -55


© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top