How Calculate Sum of Squares in Excel (Formula)

Last Updated: November 29, 2023
puneet-gogia-excel-champs

- Written by Puneet

In Excel, there is a specific function that you can use to calculate the sum of squares of numbers in a single cell. This function is called SUMQ. And refer to a range of cells or can enter values directly into the function to get the result.

Formula to Get the Sum of Squares

Below are the steps to write this formula:

  1. Type (=) in a cell to enter the function.
  2. Enter the (SUMQ) and then enter the starting parentheses.
  3. Refer to the range where you have the numbers you want to get the sum value of squares.
  4. Close the function and hit enter to get the result.
sum-of-squares

When you hit enter, it gives you a final value, the sum of the square of 25 and 25, as we have two numbers in the range A1:B1.

sumsq-to-sum-squares

To verify, we can do a manual check. The square of 25 is 625, and as we have 25 in both cells, it should be 625 + 625 = 1250. And this is what we have in the result. You can also refer to a range with multiple numbers without worrying about the count of cells.

manual-check-of-square

Note: If you are using negative numbers, you will still get the result as a positive number.

Use a Simple Maths Formula

Instead of using the function, you can use a simple formula using the caret operator (^).

math-formula-to-sum-squares
=SUM(A1^2,B1^2)

Here we have used the SUM function, and with each number, we have used the caret operator (^) to get the square of that number first. Or you can also write a formula like the following:

=A1^2+B1^2

These methods have limited use. So, if you have a long list of numbers, using the first method is better.

Get the Excel File