MMULT(A1:B2;TRANSPOSE(A3:B3))

S

sensorflo

Hello

I try to multiply a matrix with a vector. The matrix is in A1:B2, the
vector is in A3:B3. Thus I need to tranpose the vector first. I tried:
=MMULT(A1:B2;TRANSPOSE(A3:B3))
However this results in "#VALUE!". What is wrong? Since the actual
problem is more complex, I cant store the vector in another way into
cells, so that it would be already in the correct form.

Greetings

Flo
 
D

Dave Peterson

Did you hit ctrl-shift-enter and did you have a range of 2 rows by 1 column
selected when you array entered the formula.

Excel's help explains it more thoroughly.
 
B

Bernard Liengme

For a simple n by n multiplication why not use =SUMPRODUCT(A1:B1,A3:B3)
 
Top