Excel: SumX2mY2 Function

In Excel, the SumX2mY2 function returns the sum of the difference of squares between two arrays.

The syntax for the SumX2mY2 function is:

SumX2mY2( array1, array2 )

array1 and array2 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:

Based on the Excel spreadsheet above:

=SumX2mY2(A1:A2, B1:B2) would return -10

=SumX2mY2(D1:D2, E1:E2) would return -26

=SumX2mY2({3,4}, {1,2}) would return 20

=SumX2mY2({3,4,5}, {1,2,3}) would return 36