SUMSQ

The SUMSQ function in Google Sheets returns the sum of the squares of a series of numbers and/or cells. Whether you need to calculate the sum of squared values for statistical analysis or any other purpose, the SUMSQ function simplifies the task. Take a deep dive into our comprehensive guide to master its application.

Parameters

• value1: The first number or range of cells whose squares you want to sum.
• value2, ...: [Optional] Additional numbers or ranges of cells whose squares you want to sum.

Step-by-Step Tutorial

1. Using SUMSQ with individual numbers:

   • Example: =SUMSQ(3, 4, 5)
   • Result: 50

2. Using SUMSQ with a range of cells:

   • Example: If A1:A4 has the values 1, 2, 3, 4, then =SUMSQ(A1:A4) will return 30.

Working with a Single Value, a List, and a Range

SUMSQ accepts numbers one at a time, as a comma-separated list, or as a range — mix and match freely.

• Single value: =SUMSQ(A1) — returns A1 squared.
• List of values: =SUMSQ(A1, A2, A3) — squares each cell individually, then adds the results.
• Range: =SUMSQ(A1:A10) — squares and sums every cell in the range.
• Mixed: =SUMSQ(A1, A3:A6, 10) — you can combine single cells, ranges, and literal numbers in one call.

Use Cases and Scenarios

1. Statistical Analysis: Calculate the sum of squared values for data analysis.
2. Regression Analysis: Evaluate the sum of squared residuals for a regression model.
3. Error Calculation: Find the sum of squared errors to assess the accuracy of a prediction.

Related Functions

• SUM: Find the sum of a range of cells.
• SQRT: Calculate the square root of a number.

Related Articles

• Top 5 Statistical Functions Every Google Sheets User Should Know
• How to Perform Regression Analysis in Google Sheets