【问题解决】ctrl+shift+enter 在EXCEL的数组

1、=sum(b2:c2*b3:c3) with CTRL+Shift+Enter

is equivalent to

=sumproduct(B2:C2,B3:C3) with just Enter

2、Perhaps it is your keyboard. Try the ctrl & shift keys on the right side.

亲测以上两种解决方案行之有效。