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:
- Type (=) in a cell to enter the function.
- Enter the (SUMQ) and then enter the starting parentheses.
- Refer to the range where you have the numbers you want to get the sum value of squares.
- Close the function and hit enter to get the result.
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.
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.
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 (^).
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:
These methods have limited use. So, if you have a long list of numbers, using the first method is better.