Quick Navigation

SUMX2PY2 Function

Excel 2007+

Summary

The SUMX2PY2 function calculates the sum of the sum of squares of corresponding values from two arrays. This powerful statistical tool adds up (x² + y²) for each pair of values, making it essential for vector magnitude calculations and statistical analysis.

Syntax

SUMX2PY2(array_x, array_y)

Parameters

Parameter	Type	Required	Description
array_x	`Array/Range`	Yes	The first array or cell range of numeric values
array_y	`Array/Range`	Yes	The second array or cell range of numeric values

Using the SUMX2PY2 Function

SUMX2PY2 is widely used in statistical analysis to calculate the sum of squared differences between corresponding elements of two datasets. It's particularly valuable when computing Euclidean distances, vector magnitudes, or performing calculations that require the sum of squared pairwise values.

Common SUMX2PY2 Examples

Basic Range Calculation

=SUMX2PY2(A3:A9,B3:B9)

Calculates sum of squares for two vertical ranges containing corresponding values (result: 521)

Array Constants

=SUMX2PY2({2,3,9,1,8,7,5},{6,5,11,7,5,4,4})

Uses inline array constants to compute sum of pairwise squares (result: 521)

Euclidean Distance Component

=SUMX2PY2(X_coords,Y_coords)

Key component for calculating straight-line distance between point sets

Frequently Asked Questions

#N/A error is returned when array_x and array_y have unequal numbers of values.

Text, logical values, and empty cells are ignored, but zeros are included in calculations.

Yes, SUMX2PY2 works perfectly with named ranges containing numeric data.

Common Errors and Solutions

#N/A - Arrays different sizes

Cause: array_x and array_y contain different numbers of values

Solution: Ensure both arrays have identical lengths

#VALUE! error

Cause: Arguments contain non-numeric data that can't be ignored

Solution: Verify ranges contain only numbers, text, or empty cells

Notes

Formula: Σ(xi² + yi²) for i = 1 to n
Zeros contribute to the sum (0² + 0² = 0)
Available since Excel 2007
Ideal for Pythagorean distance calculations

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in: Excel 2003 and earlier

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+