The SUMPRODUCT function is great for values in arrays with the same dimensions, but you can also use the SUM function with a formula array if you need more flexibility.

• SUMPRODUCT函数适合维数相同的数组中的值,如果想要更加灵活一些,也可以将SUM函数与公式数组一起使用。