Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelSUMXMY2 Function in Excel

# SUMXMY2 Function in Excel

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

## What is SUMXMY2 Function in Excel?

The SUMXMY2 Function in Excel is used to return the sum of squares of differences between corresponding values in two arrays.

## Syntax

=SUMXMY2 (array_X ,array_Y)

Parameter

• Array_X– The first array or ranges of numeric values.
• Array_Y– The second array or ranges of numeric values

Example

=SUMXMY2 (R2:R12, S2:S12)

=SUMXMY2 ({1,2,3,4},{2,6,5,4})

## How to use SUMXMY2 Function in Excel?

The following steps will explain the work of the SUMXMY2 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 SUMXMY2 Function, let us begin with the SUMXMY2 command following the “=” operator within the parenthesis to declare the array or ranges of numeric values.

Note:

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

Share:

### 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