Math & Trig

SUMX2PY2 Function in Excel

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

Syntax

  • =SUMX2PY2(array_x, array_y)

Arguments

  • array_x (required): First array
  • array_y (required): Second array

Examples

  • =SUMX2PY2(A1:A3, B1:B3) - Sum of x²+y² - Result: Sum value

SUMX2PY2 in reporting workflows

  • Use absolute references when copying formulas across rows.
  • For conditional totals see [SUMIF](/functions/sumif/) and [SUMIFS](/functions/sumifs/).
  • Filtered lists may need [SUBTOTAL](/functions/subtotal/) instead of SUM on visible cells only.

Common errors

  • Arrays must be same size

Use cases

  • Distance calculations
  • Statistics
  • Engineering

Frequently asked questions

  • What is the SUMX2PY2 function in Excel? SUMX2PY2 returns the sum of the sum of squares of corresponding values in two arrays. The syntax is =SUMX2PY2(array_x, array_y). Typical use cases include distance calculations, statistics, engineering.
  • How do I use the SUMX2PY2 function? To use SUMX2PY2, type =SUMX2PY2( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • What happens if SUMX2PY2 encounters errors? If SUMX2PY2 encounters invalid arguments or calculation errors, it may return error values like #VALUE!, #NUM!, or #DIV/0!. Check your input values and ensure they meet the function's requirements.
  • Why is SUMX2PY2 not working in my Excel? Common issues with SUMX2PY2 include Arrays must be same size. Start by checking the syntax =SUMX2PY2(array_x, array_y), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.