Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelSUMX2MY2 Function in Excel

# SUMX2MY2 Function in Excel

In this post, let’s learn how the SUMX2MY2 Function works in excel, describes the formula syntax, and how you can use the SUMX2MY2 Function in your excel spreadsheet

## What is SUMX2MY2 Function in Excel?

The SUMX2MY2 Function is used in Excel to return the sum of the difference of squares of corresponding values in the given two arrays.

## Syntax

=SUMX2MY2 (array_x, array_y)

Parameter

• Array_x– The first range or array of numeric values.
• Array_y– The second range or array of numeric values.

Example

=SUMX2MY2(H2:H8, I2:I8)

=SUMX2MY2({1,2,3}, {7,8,9})

## How to use SUMX2MY2 Function in Excel?

The following steps will explain the work of the SUMX2MY2 function in an excel spreadsheet:

• First, prepare an excel spreadsheet with the specified details in it, or open an existing Excel spreadsheet.
• To, perform the SUMX2MY2 Function, let us begin with the SUMX2MY2 command following the “=” operator within the parenthesis to declare the array or ranges of numeric values.

Note:

The SUMX2MY2 function returns #N/A error when the arrays contain different numbers of cells.

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021