In this tutorial you will learn** How to use SUMSQ Function in Google Sheets**

You can use SUMSQ math Function to calculate the sum of squares of a set of numbers cells.

**SUMSQ function Syntax**

Syntax SUMSQ(value1, [value2, ...])

- Value 1 will be the first number or range whose squares to add together.
- Value 2 will be the Additional numbers or ranges whose squares should be added to the value1 square(s).

**How to use SUMSQ Function in Google Sheets : Step by Step Guide **

Encosed are the steps to use SUMSQ function.

In the below example we will show How to use SUMSQ Function

## Step 1 : Prepare your dataset in Google Sheet

Assume we have the following dataset in Google Sheet for which we need to calculate the sum of sqaures

## Step 2 : Use the SUMSQ function

To calculate the sum of squares for the above dataset we can use the below formula

=SUMSQ(A2:A08)

Use the above provided formula and customize it as per your dataset .

For the provided example we have used the formula =SUMSQ(A2:A8) on Cell B2.

Press enter and the sum of squares will be returned for the provided dataset

Sum of Squares is returned to be 2336

We can verify the above result with a manual calculation of sum of squares as shown below :

- Sum of squares = Σx
_{i}^{2} - Sum of squares = 10
^{2}+ 5^{2}+ 15^{2}+ 6^{2}+ 10^{2}+ 25^{2}+ 35^{2} - Sum of squares = 100 + 25 + 225 + 36 + 100+ 625 +1225
- Sum of squares = 2336

The manual calculation result matches with the SUMSQ function result which is** 2336**

**How to use SUMSQ Function in Google Sheets(Conclusion)**

In the above tutorial we have shown you an example on How to use **SUMSQ Function in Google Sheets** .We hope this tutorial was useful.

Related articles :

How to Insert Spin Button in Google Sheets ( Easy Guide )

How to Freeze Rows in Google Sheets