Excel: SumSq Function

In Excel, the SumSq function returns the sum of the squares of a series of values.

The syntax for the SumSq function is:

SumSq( value1, value2, ... value_n )

value1, value2, ... value_n are a series of numeric values that are to be squared and then summed together. There can be up to 30 values.

Applies To:

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=SumSq(A1:A2) would return 10

=SumSq(A1:A2, B1:B2) would return 30

=SumSq(3, D1:D2) would return 83

=SumSq(1, 2, 3) would return 14