Excel SUMSQ Function

What is SUMSQ Function in Excel?

The SUMSQ function is one of the math functions of Excel.

It Returns the sum of the squares of the arguments.

The arguments can be numbers, arrays, names, or references to cells that contain numbers.

We can find this function in Math & trig category of insert function Tab.

How to use SUMSQ function in excel

  1. Click on an empty cell (like F5 )
an empty cell in excel

2. Click on fx icon (or press shift+F3)

 fx icon in excel

3. In the insert function tab you will see all functions

 insert function tab in excel

4. Select math and trig category

5. Select SUMSQ function

6. Then select ok

excel SUMSQ function

7. In the function arguments Tab you will see SUMSQ function

8. Number1,number2,… are 1 to 255 numbers, arrays, names, or references to arrays for which you want the sum of the squares.

This function first obtains the square of each of the input values ​​and then adds them together.

9. You will see results in the formula result section

How to use SUMSQ function in excel

Examples of SUMSQ function in Excel

Example 1:

How to use SUMSQ function in excel

You can see examples of SUMSQ function below:

Examples of SUMSQ function in Excel
sumsq(A2,B2) ----->>>>answer is  5

sumsq(A3,B3) ----->>>>answer is  13

sumsq(A4,B4) ----->>>>answer is  25

sumsq(A5,B5) ----->>>>answer is  41

sumsq(A6,B6) ----->>>>answer is  61

What is the purpose of SUMSQ function?

It Returns the sum of the squares of the arguments.

What is the Return value of SUMSQ function?

It returns a number.

How many arguments does SUMSQ function have?

This function has just 1 Argument.

The argument of SUMSQ function is number.

Number1,number2,… are 1 to 255 numbers, arrays, names, or references to arrays for which you want the sum of the squares.

This function first obtains the square of each of the input values ​​and then adds them together.

The argument of SUMSQ function is required and not optional.

SUMSQ(number) = number

Which version of excel supports SUMSQ function?

This function is available for all excel versions (2003-2019)

Errors in SUMSQ function

SUMSQ related functions :

Leave a Reply

Your email address will not be published. Required fields are marked *