SUMX2PY2

  • Updated

Calculates the sum of the sums of the squares of values in two arrays or ranges.

Sample Usage

SUMX2PY2({2,3,11,7},{6,5,9,1})
SUMX2PY2(A2:A9,B2:B9)

Syntax

SUMX2PY2(array1, array2)

  • array1 - The first array or range to consider while calculating the sum of the sums of squares.
  • array2 - The second array or range to consider while calculating the sum of the sums of squares.


Examples

SUMXPY2({2, 3, 11, 7}, {6, 5, 9, 1}) returns the sum of the sums of the squares of values in the two arrays - this case 326 .
SUMX2PY2(A2:A9,B2:B9) returns the sum of the sums of the squares of values in two arrays - A2:A9 and B2:B9.