Excel functions / Math
MMULT function
Multiplies two matrices.
Syntax
=MMULT(array1, array2)
Arguments
array1: The first matrix.array2: The second matrix, with as many rows as the first has columns.
When to use it
MMULT multiplies two matrices: each cell of the result is a row of the first times a column of the second, added up. The first must have as many columns as the second has rows. It spills the result.
Away from algebra, it totals a table of quantities against a list of prices in one formula.
Examples
The cost of each order
A B C D E 1 Order Pens Pads 2 A 10 2 21 3 B 4 5 21 4 5 Price 6 1.5 7 3 In E2:
=MMULT(B2:C3, A6:A7)→ 21; 2110 pens and 2 pads cost 21; so do 4 pens and 5 pads.
Common mistakes
- Sizes that do not fit. If the first matrix's columns do not match the second's rows, the result is #VALUE!.
- Multiplying cell by cell. To multiply two ranges cell by cell, use * between them. MMULT is the matrix product.
MMULT in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: SOUČIN.MATIC
- Danish: MPRODUKT
- Dutch: PRODUCTMAT
- Finnish: MKERRO
- French: PRODUITMAT
- German: MMULT
- Hungarian: MSZORZAT
- Italian: MATR.PRODOTTO
- Norwegian: MMULT
- Polish: MACIERZ.ILOCZYN
- Portuguese (Brazil): MATRIZ.MULT
- Portuguese (Portugal): MATRIZ.MULT
- Russian: МУМНОЖ
- Spanish: MMULT
- Swedish: MMULT
- Turkish: DÇARP
Related functions
- SUMPRODUCT: Multiplies matching items in arrays, then adds the results.
- MINVERSE: The inverse of a square matrix.
- MDETERM: The determinant of a square matrix.
- TRANSPOSE: Flips rows into columns and columns into rows.