SUMSQ

Excel Functions

Get sum of squares of supplied values

Syntax

EXCEL

=SUMSQ(number1, [number2], ...)

Arguments

Parameter	Description
`number1`	The first argument containing numeric values.
`number2`	[optional] The first argument containing numeric values.

Return Value

Calculated sum of squares

Details

The SUMSQ function returns the sum of the squares of the numbers provided. SUMSQ takes multiple arguments in the form number1, number2, number3, etc. up to 255 total. Arguments can be a hardcoded constant, a cell reference, or a range. All numbers in the arguments provided are squared then summed. The SUMSQ function automatically ignores empty cells and text values. In the worksheet shown, the formula in H5, copied down, is: Notice that SUMSQ automatically ignores empty cells and text values.

Examples

EXCEL

=SUMSQ(1,2) // returns 5
=SUMSQ(1,2,3) // returns 14
=SUMSQ({1,2,3}) // returns 14

Examples

In the worksheet shown, the formula in H5, copied down, is:

EXCEL

=SUMSQ(B5:F5) // returns 5

SUMSQ

Syntax

Arguments

Return Value

Details

Examples

See Also