Excel Sumx2Py2 Function
SUMX2PY2 takes two arguments, array_x and array_y. Array_x is the first range or array or range of numbers, and array_y is the second range or array of numbers. Both arguments can be provided as an array constant or as a range. Examples In the example shown above, the formula in E5 is: which returns 600 as a result. Equation The equation used to calculate the sum of the sum of squares is: This formula can be created manually in Excel with the exponentiation operator (^) like this: With the example as shown, the formula below will return the same result as SUMX2PY2:...