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.’