Navigation:  Formula Reference > Spreadsheet Formula Functions >

SUMX2PY2

Previous pageReturn to chapter overviewNext page

 

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

Syntax

SUMX2PY2(array_x,array_y)

Arguments

This function has these arguments:

Argument

Description

array_x

First array of values (x’s)

array_y

Second array of values (y’s)

The arrays must be the same size.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

SUMX2PY2(A1:A17,B1:B17)

 

See Also

SUM

SUMX2MY2

SUMXMY2