- Picture and text skills
- Case
Calculate the sum of the squares of the corresponding values in the two arrays.
Syntax
SUMX2PY2 (array_x, array_y)
Array_x The first array or numerical range.
Array_y The second array or numerical area.
Description
Parameters can be values, arrays, names, or array references.
If the array or reference parameter contains text, logical values, and blank cells, these values will be ignored; however, cells containing zero values will be counted.
If array_x and array_y have different numbers of elements, SUMX2PY2 will return the error value #N/A.
The calculation formula for the sum of squares is as follows:
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/shu-xue-he-san-jiao-han-shu-SUMX2PY2-han-shu.html
支付宝扫一扫 
评论列表（196条）
测试