SUMX2MY2 Function in Excel 

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

What is SUMX2MY2 Function in Excel? 

The SUMX2MY2 Function is used in Excel to return the sum of the difference of squares of corresponding values in the given two arrays.   


=SUMX2MY2 (array_x, array_y) 


  • Array_x– The first range or array of numeric values. 
  • Array_y– The second range or array of numeric values. 


=SUMX2MY2(H2:H8, I2:I8) 

=SUMX2MY2({1,2,3}, {7,8,9}) 

How to use SUMX2MY2 Function in Excel? 

The following steps will explain the work of the SUMX2MY2 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 SUMX2MY2 Function, let us begin with the SUMX2MY2 command following the “=” operator within the parenthesis to declare the array or ranges of numeric values. 
we have performed SUMX2MY2 Function in Excel spreadsheet


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