SUMSQ
Formulas / SUMSQCalculate 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.
Need help with Formulas?
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)
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.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.
Drop CSV