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 (^).

`=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.