Excel functions / Math

MMULT function

Multiplies two matrices.

Syntax

=MMULT(array1, array2)

Arguments

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

  1. The cost of each order

    ABCDE
    1OrderPensPads
    2A10221
    3B4521
    4
    5Price
    61.5
    73

    In E2: =MMULT(B2:C3, A6:A7) → 21; 21

    10 pens and 2 pads cost 21; so do 4 pens and 5 pads.

    Try this example

Common mistakes

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.

Translate a whole formula

Try MMULT in the playground

Related functions