Column multiplied by a matrix
 

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?

Column multiplied by a matrix
 

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

NOTE that =SUMPRODUCT(A1:A3,B1:D3) will give #VALUE! error
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"StephenT" wrote in message
...
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?

Column multiplied by a matrix
 

Check out: =SUMPRODUCT((A1:A3)*(B1:D3))
Micky


"StephenT" wrote:

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?