Whole document tree SUMX2PY2DescriptionSUMX2PY2 function returns the sum of the sum of squares of corresponding values in two arrays. @array1 is the first array or range of data points and @array2 is the second array or range of data points. The equation of SUMX2PY2 is SUM (x^2+y^2). Strings and empty cells are simply ignored. If @array1 and @array2 have different number of data points, SUMX2PY2 returns #N/A error. This function is Excel compatible. |