MMULT

Using the Excel MMULT Function

Summary

The Excel MMULT function performs matrix multiplication and returns the matrix product of two arrays. The final result will be an array that has the same number of rows as array1 and the same number of columns as array2.

Syntax

=MMULT (array1, array2)

Syntax Breakdown

Array1
Required. The first array you want to multiply.

Array2
Required. The second array you want to multiply.


Usage Notes

MMULT performs matrix multiplication, returning the product of two arrays. The output will have the same number of rows as array1 and the same number of columns as array2. Both array1 and array2 may only contain numbers; though they can also be provided as cell ranges, array constants, or references.

When using MMULT it is critical to ensure that the number of columns in array1 is the same as the number of rows in array2.

You must enter formulas that return arrays as an array formula by using Control + Shift + Enter. Pressing just Enter will return an incorrect result:

Excel MMULT Output Error

MMULT #VALUE! Error
The MMULT function returns the #VALUE! error if:
  • Any cells are empty or contain text;
  • The number of columns in array1 is not the same as the number of rows in array2.