Excel: SumXmY2 Function

In Excel, the SumXmY2 function calculates the sum of the squares of the differences between corresponding items in the arrays and returns the sum of the results.

The syntax for the SumXmY2 function is:

SumXmY2( array1, array2 )

array1 and array are two ranges or arrays.

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

=SumXmY2({1,2;3,4}, {5,6;7,8})

The above example would return 64.

You could also reference ranges in Excel.

Based on the Excel spreadsheet above, you could enter the following formula:

=SumXmY2(A1:B2, D1:E2)

This would also return the value 64.