SUMX2PY2 Function in Excel

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

What is SUMX2PY2 Function in Excel? 

The SUMX2PY2 Function is used in Excel to return the sum of the square of the corresponding values in the given arrays. 


=SUMX2PY2 (array_x, array_y) 


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


=SUMX2PY2(S2:S8, T2:T8) 

=SUMX2PY2({1,5,3}, {7,5,9}) 

How to use SUMX2PY2 Function in Excel? 

The following steps will explain the working of the SUMXPY2 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 SUMXPY2 Function, let us begin with the SUMX2PY2 command following the “=” operator within the parenthesis to declare  
we have performed SUMX2PY2 Function in excel spreadsheet


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