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
- Click on an empty cell (like F5 )
2. Click on fx icon (or press shift+F3)
3. In the insert function tab you will see all functions
4. Select math and trig category
5. Select SUMSQ function
6. Then select ok
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
Examples of SUMSQ function in Excel
Example 1:
How to use SUMSQ function in excel
You can see examples of SUMSQ function below:
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 61What 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)
