HomeMicrosoft OfficeExcelSUMXMY2 Function in Excel

SUMXMY2 Function in Excel

In this post, let’s learn how the SUMXMY2 Function works in excel, describes the formula syntax, and how you can use the SUMXMY2 Function in your excel spreadsheet

What is SUMXMY2 Function in Excel? 

The SUMXMY2 Function in Excel is used to return the sum of squares of differences between corresponding values in two arrays. 

Syntax 

=SUMXMY2 (array_X ,array_Y) 

Parameter 

  • Array_X– The first array or ranges of numeric values. 
  • Array_Y– The second array or ranges of numeric values 

Example 

=SUMXMY2 (R2:R12, S2:S12) 

=SUMXMY2 ({1,2,3,4},{2,6,5,4}) 

How to use SUMXMY2 Function in Excel? 

The following steps will explain the work of the SUMXMY2 function in an excel spreadsheet:      

  • First, prepare an excel spreadsheet with the specified details in it, or open an existing Excel spreadsheet.   
  • To, perform the SUMXMY2 Function, let us begin with the SUMXMY2 command following the “=” operator within the parenthesis to declare the array or ranges of numeric values.  
How to use SUMXMY2 Function in Excel? 

Note: 

  • The SUMXMY2 function returns #N/A error when the arrays contain different numbers of cells. 

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021