Syntax

SUMX2MY2(array_x, array_y)

Arguments

The printed syntax lists 2 argument(s), in order:

  • array_x
  • array_y

“optional” marks an argument Google prints in square brackets; “repeatable” marks one Google prints with “…”.

Description from Google Docs Editors Help

“Calculates the sum of the differences of the squares of values in two arrays.”

Google’s help article for SUMX2MY2 →

Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), record record 498 of 516, data fetched 28 September 2026. Data month: September 2026.