S
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?
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?