## How to use the SUMX2PY2 function

*Article updated on March 13, 2018*

The SUMX2PY2 function calculates the sum of the sum of squares of corresponding values in two arrays.

The sum of the sum of squares is a common procedure in many statistical calculations.

Formula in cell F3:

4^2 + 3^2 + 4^2 = 41

2^2 + 3^2 + 4^2 = 29

41 + 29 = 70

### Excel Function Syntax

SUMX2MY2(*array_x*, *array_y*)

### Arguments

array_x |
Required. The first array or range of values. |

array_y |
Required. The second array or range of values. |

### Functions in 'Math and trigonometry'

The SUMX2PY2 function function is one of many functions in the 'Math and trigonometry' category.