mmult

I Encounter the following:

Please Login or Register  to view this content.

I though that MMULT would do

Please Login or Register  to view this content.

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

Making

Please Login or Register  to view this content.

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.