Skip to content
Excel

SUMSQ function in Excel

Returns the sum of the squares of the arguments

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

SUMSQ syntax and parameters

Two arguments, one required.

  • number1numberRequired
  • number2numberRepeating

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 Google Sheets

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 Excel gets this done.