Column multiplied by a matrix

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

Bernard Liengme

=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
 
×

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Arriving at totals 2
excel copy and paste... 2
Paragraph numbering in Word 1
Creating Different Headers in Word 0
Adding rota 0
Numbers from first column 6
lookup matrix 1
Return last non-blank cell in column 3

Top