- Picture and text skills
- Case
Calculate the sum of squares of the differences between corresponding values in two arrays.
Syntax
SUMXMY2 (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, SUMXMY2 will return the error value #N/A.
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-SUMXMY2-han-shu.html
支付宝扫一扫 
评论列表（196条）
测试