You can use SUMPRODUCT to calculate the scalar product of two vectors. SUMPRODUCT returns a single number, it is not necessary to enter the function as an array function.
SUMPRODUCT を使用すると、2 つの範囲のスカラー積を計算できます。