Math and Trignometric - SUMX2PY2 Function

Description

The SUMX2PY2 function returns the sum of the sum of squares of corresponding values in two arrays.

Syntax

SUMX2PY2 (array_x, array_y)

Arguments

Argument Description Required/Optional
Array_x The first array or range of values. Required
Array_y The second array or range of values. Required

Notes

  • The arguments should be either numbers or names, arrays, or references that contain numbers.

  • If an array or reference argument contains text, logical values, or empty cells, those values are ignored. However, cells with the value zero are included.

  • If array_x and array_y have a different number of values, SUMX2PY2 returns the #N/A error value.

  • The equation for the sum of the sum of squares is −

    $$SUMX2PY2 = \sum \left ( x^2+y^2 \right )$$

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

SUMX2PY2 Function
advanced_excel_math_trigonometric_functions.htm
Advertisements