Skip to content
Excel

MMULT function in Excel

Returns the matrix product of two arrays

=MMULT(array1, array2)

MMULT syntax and parameters

Two arguments, two required.

  • array1arrayRequired
  • array2arrayRequired

MMULT examples

Formulas you'll actually reuse.

  1. A 3×3 matrix times a 3×1 vector — e.g. a transition matrix applied to a population:

    =MMULT(B2:D4, F2:F4)

  2. A dot product of two columns via a 1×12 · 12×1 multiply:

    =MMULT(TRANSPOSE(B2:B13), C2:C13)

    Result12480.5

MMULT in Google Sheets

Same name — your formula ports as-is.

Try MMULT in the playground

Edit the example — nothing to install.

Preloaded with the MMULT formula from Example 1 — change anything and watch it respond.

Loading the editor…

MMULT errors

What they mean — and the fixes.

  • #VALUE!

    The first array's column count doesn't equal the second array's row count — that is the rule for matrix multiplication.

Related functions

More ways Excel gets this done.