MMULT Array Function

[millhouse123]

I am not getting the expect result when I multiply two arrays

Array1
1 5 2 4
1/5 1 1/2 1/2
1/2 2 1 2
1/4 2 1/2 1


Array2
0.5115
0.0986
0.2433
0.1466


Expected Result
2.0774
0.3958
0.9894
0.5933

My result
2.0774
2.0774
2.0774
2.0774


I am sure I am entering them as array formulas but I am not getting the right answer. I am sure this is something simple. Thanks for your help.

 

[Oaktree]

Select H1:H4 (or whatever the desired destination is), type the formula =MMULT(A1:D4,F1:F4) adjusting the ranges to suit, and press CTRL+SHIFT+ENTER to enter it as an array formula.

 

[Aladin Akyurek]

Assuming that Array 1 is in A1:D4 and Array 2 in F1:F4...

In H1 enter & copy down:

=INDEX(MMULT($A$1:$D$4,$F$1:$F$4),ROWS(H$1:H1))

 

[millhouse123]

Thanks Guys - I need to use these array formulas more they are very helpful.