Learn How to Use Microsoft Excel SUMX2MY2 Function

Microsoft Excel SUMX2MY2 Function

The main function of the Microsoft Excel SUMX2MY2 function is to get the sum of the difference of squares in two arrays. That implies, with the help of the SUMX2MY2 function you can able to get a sum of the difference of squares corresponding to the values n 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 SUMX2MY2 function, you can able to get the sum of the difference of squares in two arrays.

Return Value of SUMX2MY2 Function

The return value will be the calculated sum of the difference of squares.

Syntax of SUMX2MY2 Function

=SUMX2MY2(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 SUMX2MY2 Function?

So we know that Microsoft Excel SUMX2MY2 function you can able to get the sum of the difference of squares in two arrays. That implies, with the help of the SUMX2MY2 function you can able to get the sum of the difference of squares corresponding to the values n 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 SUMX2MY2 function, you can able to get the sum of the difference of squares in two arrays.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel