SUMX2PY2() function

Functions Jun 08, 2019

The SUMX2PY2() function is a Math and Trig function that returns the summation of squares of 2 arrays. It keeps 2 parameters and they are array_x, array_y.

Where to apply :

This function is used in education and to do some mathematical calculations.

Syntax :

=SUMX2PY2(array_x, array_y)

Parameters :

array_x - A list of items and numbers or a range.

array_y - A list of items and numbers or a range.

Remember - The count of item of both the arrays should be equal.


1. To get the summation of squares of 2 numbers.

=SUMX2PY2(6, 8)    // Returns (100)

It returns 100 that is the summation of squares of 6 (36) and 8 (64).

Excel based example:

Image 1 - SUMX2PY2() function

The SUMX2PY2() function is well explained in above image.

Hope, it would have added in your Excel function knowledge.

Thank You!

Best Excel training institute in Noida provides Basic Excel, Advance Excel and VBA offline and online classes.

If you want to learn Excel & VBA courses to be Excel expert, connect us on:

9599408486 / 8929231250

Manoj kumar

Corporate Trainer at ExcelHour. I have devoted over 9 years to various industries for learning multiple data challenges and trained Excel and VBA courses to the corporate along with offline training.

Great! You've successfully subscribed.
Great! Next, complete checkout for full access.
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.