SUMX2PY2 Function Explained
The SUMX2PY2 Function in Microsoft Excel adds the sum of two squares of two different sets of numbers. It takes four arguments: x, y, sum_x, and sum_y. x and y are the two sets of numbers, and sum_x and sum_y are the sums of the squares of the two sets of numbers. The function returns the sum of the two squares.
SUMX2PY2 Function Syntax
SUMX2PY2(array_x, array_y)
- array_x: An array of numbers or range of cells to be added together.
- array_y: An array of numbers or range of cells to be added together.