Spread Formula Reference
Formula Functions / Functions R to S / SUMSQ
In This Topic
    SUMSQ
    In This Topic

    This function returns the sum of the squares of the arguments.

    Syntax

    SUMSQ(value1,value2,...)

    SUMSQ(array)

    SUMSQ(array1,array2,...)

    Arguments

    Each argument can be a double-precision floating-point value, an integer value, or an array (cell range) of these. Up to 255 arguments may be included. You can use a single array (cell range) instead of a list of values. You can use multiple arrays (cell ranges) as well.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    SUMSQ(A1,B7,C11)

    SUMSQ(A1:A9)

    SUMSQ(R1C2,R3C5,R6C2,R1C7)

    SUMSQ(95,89,73,87,85,76,100,96,96) gives the result 71277

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    SUMPRODUCT | SUM | Math and Trigonometry Functions