# Learn How to Use Microsoft Excel SUMX2PY2 Function

Written by | 0 Comments | 586 Views

In this article, you will learn how to use the Microsoft Excel SUMX2PY2 function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel SUMX2PY2 function return value and syntax with the help of some examples.

Microsoft Excel SUMX2PY2 Function

The main function of the Microsoft Excel SUMX2PY2 function is to get the sum of squares in two arrays. That implies, with the help of the SUMX2PY2 function you can able to get the sum of the squares corresponding in two arrays. It should be noted that the values that you provided can be in the form of constants, cell references, or ranges. So, with the help of the SUMX2PY2 function, you can able to get the sum of squares in two arrays.

Return Value of SUMX2PY2 Function

The return value will be the calculated sum of squares.

Syntax of SUMX2PY2 Function

=SUMX2PY2(array-x, array-y)

Where the arguments:

• array-x: This is the first range or array containing numeric values.
• array-y: This is the second range or array containing numeric values (optional).

## How to Use Microsoft Excel SUMX2PY2 Function? So we know that Microsoft Excel SUMX2PY2 function you can able to get the sum of squares in two arrays. That implies, with the help of the SUMX2PY2 function you can able to get the sum of the squares of the corresponding two arrays. It should be noted that the values that you provided can be in the form of constants, cell references, or ranges. So, with the help of the SUMX2PY2 function, you can able to get the sum of squares in two arrays.