Column multiplied by a matrix

[StephenT]

Hello

Can anyone tell me how to multiply all the numbers in a column by all the
numbers in a matrix?

eg Column of numbers in A, multiplied by matrix of numbers in C1:E3
A B C D E
1 3 6 7 8
2 4 7 8 9
3 5 6 8 9

So I would like a formula which SUMS

3*6 + 3*7 + 3*8 + 4*7+4*8+4*9 + 5*6 + 5*8 + 5*9

thanks
S

Can this be done without creating a second matrix with column A spread out?

 

[Bernard Liengme]

=SUMPRODUCT(A1:A3*B13)
give 274 with your data - as required

NOTE that =SUMPRODUCT(A1:A3,B13) will give #VALUE! error
best wishes

 

[מיכ×ל (מיקי) ×בידן]

Check out: =SUMPRODUCT((A1:A3)*(B13))
Micky