Using the Excel MMULT Function
SummaryThe 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)
Required. The first array you want to multiply.
Required. The second array you want to multiply.
Usage NotesMMULT 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:
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.