Spread.NET 17 Formula Reference
Formula Functions / Functions R to S / SUMX2MY2
In This Topic
    SUMX2MY2
    In This Topic

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

    Syntax

    SUMX2MY2(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

    SUMX2MY2(A1:A17,B1:B17)

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    SUMX2PY2 | SUMXMY2 | SUM | Math and Trigonometry Functions