You can use the **SUMSQ **function in Google Sheets to calculate the sum of squares for a given sample.

This function uses the following basic syntax:

**=SUMSQ(value1, value2, value3, ...)**

Here’s the formula that **SUMSQ **actually uses:

Sum of squares = Σx_{i}^{2}

where:

**Σ**: A fancy symbol that means “sum”**x**: The i_{i}^{th}data value

The following example shows how to use this function in practice.

**Example: How to Use DEVSQ in Google Sheets**

Suppose we have the following dataset in Google Sheets:

We can use the following formula to calculated the sum of squares for this dataset:

=SUMSQ(A2:A13)

The following screenshot shows how to use this formula in practice:

The sum of squares turns out to be **1,402**.

We can confirm this is correct by manually calculating the sum of squares for this dataset:

- Sum of squares = Σx
_{i}^{2} - Sum of squares = 2
^{2}+ 3^{2}+ 5^{2}+ 5^{2}+ 7^{2}+ 8^{2}+ 9^{2}+ 12^{2}+ 14^{2}+ 15^{2}+ 16^{2}+ 18^{2} - Sum of squares = 4 + 9 + 25 + 25 + 49 + 64 + 81 + 144 + 196 + 225 + 256 + 324
- Sum of squares =
**1,402**

The sum of squares turns out to be **1,402**.

This matches the value that we calculated using the **SUMSQ** function.

**Additional Resources**

The following tutorials explain how to perform other common operations in Google Sheets:

How to Use DEVSQ in Google Sheets

How to Use SUMIF with Multiple Columns in Google Sheets

How to Sum Across Multiple Sheets in Google Sheets