20.7 C
London
Saturday, July 26, 2025
HomeSoftware TutorialsGoogle SheetsHow to Use SUMSQ in Google Sheets (With Example)

How to Use SUMSQ in Google Sheets (With Example)

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

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 = Σxi2

where:

  • Σ: A fancy symbol that means “sum”
  • xi: The ith 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:

SUMSQ function in Google Sheets

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 = Σxi2
  • Sum of squares = 22 + 32 + 52 + 52 + 72 + 82 + 92 + 122 + 142 + 152 + 162 + 182
  • 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

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories