Hello

I have two questions.

Question 1. Let B1:K1 is a vector.

Now I aim to
A2 be inner product B2:K2 and B1:K1
A3 be inner product B3:K3 and B1:K1
A4 be inner product B4:K4 and B1:K1
...
A50 be inner product B50:K50 and B1:K1
.
I used "SUMPRODUCT" function for A2. But by dragging fill handle to copy the formula fo A3..A50, result is wrong.

Question 2. I copy "3 * 0.43 + 7-10" from word 2010 to D1 in excel but not calculate. how can copy from word to excel and auto calculate?

Very thankful.