How to use SUMSQ Function in Google Sheets(Quick & Easy Guide )

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

How To Sum Values In Rows & Col...
How To Sum Values In Rows & Columns - MS Excel

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.

How to use SUMSQ Function in Google Sheets

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 = Σxi2
  • Sum of squares = 102 + 52 + 152 + 62 + 102 + 252 + 352 
  • 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

How To Transpose Data in Google Sheets

How to count non-empty cells in google sheets