Formulas > =SUMXMY2()

How To Use SUMXMY2() Function in Google Sheets


Calculates the sum of the squares of differences of values in two arrays.

Common Questions about SUMXMY2 Formula:

Q. What does the SUMXMY2 formula do? 
A. The SUMXMY2 formula multiplies corresponding components in two vectors (arrays of numbers) and then calculates the sum of them.

Q. How can the SUMXMY2 formula be used appropriately? 
A. The SUMXMY2 formula can be used to calculate a sum of products of the corresponding components in two vectors, or to calculate a sum of products of the elements of two multi-dimensional arrays. 

Q. How can the SUMXMY2 formula be commonly mistyped? 
A. Commonly mistyped forms of the SUMXMY2 formula include SUMMY2X, SUMXY2, and SUMX2MY.

Q. What are some common ways the SUMXMY2 formula is used inappropriately? 
A. The SUMXMY2 formula should only be used for multiplications and summations of the individual elements of two vectors or multi-dimension arrays. It should not be used to calculate a product of two arrays. 

Q. What are some common pitfalls when using the SUMXMY2 formula? 
A. A common pitfall when using the SUMXMY2 formula is incorrectly formatting the input vectors or matrices. The formula will output incorrect results if the formatting is incorrect. 

Q. What are common mistakes when using the SUMXMY2 Formula? 
A. Common mistakes when using the SUMXMY2 formula include typing the formula incorrectly, not formatting input correctly, and not accounting for vectors of different lengths.

Q. What are common misconceptions people might have with the SUMXMY2 Formula? 
A. A common misconception people might have with the SUMXMY2 formula is that it is suitable for use with non-numeric values, such as strings or dates. The SUMXMY2 formula can only be used correctly with numerical values.

How To Actually Use SUMXMY2() in Sheets

SUMXMY2(array_x, array_y)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the SUMXMY2() formula:

LOGEST vs. LINEST in Google Sheets

This video shows the difference between LOGEST and LINEST function in Google Sheets by Phillip John Jarina.

Generate a SUMXMY2() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.