Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelSUMX2PY2 Function in Excel

# SUMX2PY2 Function in Excel

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

## What is SUMX2PY2 Function in Excel?

The SUMX2PY2 Function is used in Excel to return the sum of the square of the corresponding values in the given arrays.

## Syntax

=SUMX2PY2 (array_x, array_y)

Parameter

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

Example

=SUMX2PY2(S2:S8, T2:T8)

=SUMX2PY2({1,5,3}, {7,5,9})

## How to use SUMX2PY2 Function in Excel?

The following steps will explain the working of the SUMXPY2 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 SUMXPY2 Function, let us begin with the SUMX2PY2 command following the “=” operator within the parenthesis to declare

Note:

The SUMX2PY2 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