Excel SUMSQ Function

Summary
The Excel SUMSQ function returns the sum of the squares of the values provided. Values can be supplied as constants, cell references, or ranges.
Purpose
Get sum of squares of supplied values
Return value
Calculated sum of squares
Syntax
=SUMSQ (number1, [number2], ...)
Arguments
- number1 - The first argument containing numeric values.
- number2 - [optional] The first argument containing numeric values.
Version
Usage notes
The SUMSQ function returns the sum of the squares of the values provided. You can supply values as constants, references or ranges. Values can be supplied as individual references or as ranges (as in the example shown above). SUMSQ can handle up to 255 separate arguments.
Examples
In the example shown, the formula in G5, copied down, is:
=SUMSQ(B5:F5) // returns 5
Notice that SUMSQ automatically ignores empty cells and text values.
Notes
- Arguments can any 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.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.