Purpose
Return value
Syntax
=SUMSQ(number1,[number2],...)- number1 - The first argument containing numeric values.
- number2 - [optional] The first argument containing numeric values.
How to use
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.
Examples
=SUMSQ(1,2) // returns 5
=SUMSQ(1,2,3) // returns 14
=SUMSQ({1,2,3}) // returns 14
In the worksheet shown, the formula in H5, copied down, is:
=SUMSQ(B5:F5) // returns 5
Notice that SUMSQ automatically ignores empty cells and text values.
Notes
- Arguments can be a mix of constants, names, arrays, or references that contain numbers.
- Empty cells, logical values, and text values are ignored when they appear in arrays or references.
- The logical values TRUE and FALSE are evaluated as 1 and 0 respectively, but only when they are hardcoded as arguments.
- Numbers entered as text (i.e. "1", "3", etc.) are evaluated, but only when they are hardcoded as arguments.
Related functions
SUMSQ Function
The Excel SUMSQ function returns the sum of the squares of the values provided. Values can be supplied as constants, cell references, or ranges.
SUMX2MY2 Function
The Excel SUMX2PY2 function returns the sum of the difference of squares of corresponding values in two arrays. Values can be supplied as constants, cell references, or ranges.
SUMX2PY2 Function
The Excel SUMX2PY2 function returns the sum of the sum of squares of corresponding values in two arrays. Values can be supplied as constants, cell references, or ranges.
SUMXMY2 Function
The Excel SUMXMY2 function returns the sum of squares of differences between corresponding values in two arrays. Values can be supplied as constants, cell references, or ranges.
