Skip to Content

SUMX2MY2

Returns the sum of the difference of squares of corresponding values in two arrays

Syntax

SUMX2MY2(array_x, array_y)

Parameters

  • array_x: Required. The first array or range of values
  • array_y: Required. The second array or range of values

Example

=SUMX2MY2(A1:A5, B1:B5)
Returns: NumberSince: Excel 2003