SUMSQ

Formulas / SUMSQ
Calculate the sum of the squares of the provided values.
=SUMSQ(number1,[number2],...)
  • number1 - required, numeric value
  • number2 - [OPTIONAL] numeric value

Examples

  • =SUMSQ(1,2)

    This returns the square of each number added together. In this example, 1 and 2 are squared, then added together. Therefore, the result is 5.

  • =SUMSQ(1,2,3)

    This also returns the sum of squares of each number. In this example, 1, 2, and 3 are squared, then added together. Therefore, the result is 14.

  • =SUMSQ({1,2,3})

    This is the same as the previous example. However, this example uses curly brackets ({}) to enclose the list of numbers. Therefore, the result is also 14.

Summary

The SUMSQ function adds the squares of its arguments, which can be numbers, names, arrays, or references. All arguments must contain numbers.

  • The SUMSQ function takes numerical arguments, which can be hardcoded values, cell references, or ranges.
  • The SUMSQ function ignores empty cells and text values, as well as logical values and text values.


Frequently Asked Questions

What is the SUMSQ function?
The SUMSQ function is a built-in Sourcetable function that returns the sum of the squares of the arguments.
What types of arguments can the SUMSQ function take?
The SUMSQ function can take numerical arguments, name arguments, array arguments and reference arguments.
How do I use the SUMSQ function?
To use the SUMSQ function, type "SUMSQ" followed by the arguments you want to sum the squares of. Here's an example of how to use the SUMSQ function:
SUMSQ(A1, 10, B1:B10)
What is the syntax of the SUMSQ function?
The syntax of the SUMSQ function is:
  • SUMSQ(number1, [number2], ...)
Where number1, number2, etc. are numerical arguments, name arguments, array arguments or reference arguments.
Sourcetable Logo

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code.

Drop CSV