Skip to content
Google Sheets

SUMSQ function in Google Sheets

Returns the sum of the squares of a series of numbers and/or cells.

=SUMSQ(value1, [value2, ...])

SUMSQ syntax and parameters

Two arguments, one required.

  • value1anyRequired

    The first number or range whose squares to add together.

  • value2anyRepeating

    [ OPTIONAL ] - Additional numbers or ranges whose squares to add to the square(s) of value1.

SUMSQ examples

Formulas you'll actually reuse.

  1. Sum of squared errors between forecast and actual:

    =SUMSQ(B2:B50 - C2:C50)

    Result58240

  2. The length of a 3-D vector — root of the sum of squares:

    =SQRT(SUMSQ(B2, C2, D2))

    Result7.07

SUMSQ in Excel

Same name — your formula ports as-is.

Try SUMSQ in the playground

Edit the example — nothing to install.

Preloaded with the SUMSQ formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.