Share with you the experience of SUMX2PY2 function tips, as follows:
WPS office 2019 edition
In mathematical operations, we often encounter the situation of finding the sum of squares of the corresponding values in two arrays. Using the sumx2py2 function in the WPS table can help us calculate quickly.
Next, we'll show you the steps to use this function in this table.
Select cell D2, click Insert Function, search in the search box and select the sumx2py2 function, then click OK; The Ψa dialog box pops up with two parameters: the first set of values and the second set of values, in which you can fill in a number, an array, a name, or an array reference. It should be noted that:
If the array or reference parameter contains text, logical values, and blank cells, these values are ignored, but cells containing zero values are counted.
If it is helpful to you, you are welcome to vote and pay attention, and have dry goods to share for a long time