In Microsoft Excel, the purpose of the SUMSQ function is to return the sum of the square of the arguments. The formula for the SUMSQ function is =SUMSQ(number1,[number2]). The syntax for the SUMSQ function is below:
- Number 1: The first argument you want the sum of squares. It is required.
- Number 2: The second argument. It is optional.
How to use the SUMSQ function in Excel
- Launch Microsoft Excel.
- Create a table or use an existing table from your files.
- Place the formula into the cell you want to see the result.
- Press the enter Key.
Launch Microsoft Excel.
Create a table or use an existing table from your files.
Place the formula =SUMSQ(A2:B2) into the cell you want to see the result.
Press the enter key to see the result.
Drag the fill handle down to see the other results.
There are two other methods to use the SUMSQ function.
Method one is to click the fx button on the top left of the Excel worksheet.
An Insert Function dialog box will appear.
Inside the dialog box in the section, Select a Category, select Math and Trigonometry from the list box.
In the section Select a Function, choose the SUMSQ function from the list.
Then click OK.
A Function Arguments dialog box will open.
The references cell A2 and cell B2 will automatically appear in the Number 1 entry box even if you add more columns and select the fx button, choose the SUMSQ function, and the argument dialog box opens, it will still automatically show the references in Number 1 entry box.
Then click OK.
Method two is to click the Formulas tab, click the Math and Trigonometry button in the Function Library group.
Then select SUMSQ from the drop-down menu.
A Function Arguments dialog box will open.
We hope this tutorial helps you understand how to use the SUMSQ function in Microsoft Excel; if you have questions about the tutorial, let us know in the comments.
Read next: How to change the Color of an Error Indicator in Excel
How to use AutoSum function?
Select a cell next to the numbers you want to sum, click AutoSum on the Home tab in the Editing group, and select Sum from the menu. When users click the Sum, Excel automatically enters the formula; Press enter to see the result.
What is SUMXMY2 in Excel mean?
SUMXMY2 is a Math and Trigonometry function in Microsoft Excel, and its purpose is to return the sum of squares of differences of corresponding values in arrays. The ‘M’ in the function means minus as in ‘sum x minus y squared.’