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?