mmult

I Encounter the following:

Array 1	
1	3
7	2
Array 2	
2	0
0	2
Formula	
2 (result of {=MMULT(A2:B3,A5:B6)}

I though that MMULT would do

=A2*A5+B2*A6 + A2*B5+B2*B6 + A3*A5+B3*A6 + A3*B5+B3*B6

and the result = 26. Even if I make it an array function it comes with 2 as a result.

Making

SUMPRODUCT(MMULT(A2:B3,A5:B6))

gives the correct result (26).

MMULT will return an Array of values - ie 2 is the first result {2,6;14,4}

=SUM(MMULT(A2:B3,A5:B6))

would return 26

Thank you. I feel a bit stupid, but it now makes sence.