The Use of "SUMX2PY2" Formula in Your Excel

Hello good people, I'm here to tell you about some formula in your excel which you probably don't know of it. Have you heard the "SUMX2PY2" formula? basically, it is sum formula as well. I have exlained a kind of sum formulas in excel in previous article, of course it have many formula in there. Let's think as simple as possible. In here, sum is summation, well, the "SUMX2PY2" formula is usable for counting summation from square summation in some range. This example might make this things easier for you:

It seems the data which I chose was like this: 1^2 + 2^2 + 6^2 + 5^2 = 66

What if I block the range Data 1 until Data 2 and Data 3? Let's see:

What a coincidence! The outcome is an error function. How could it be? Then you have to block for each lane (array) in "SUMX2PY2" formula. Like this:

You can try the horizontal mode instead the vertical mode above. Unfortunately, you cannot execuse it in many arrays, this formula only have two arrays. So this is it which I illustrate you easily. Interested to try in you excel? Many cases study which you can do it, this is necessary in administration on your work. Meet me on my YouTube Channel to have all those things! This is the video version which you can watch it in "The Use of "SUMX2PY2" Formula in Your Excel"