MMULT Function
Multiplies two matrices.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
An array
Want to practice MMULT in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
MMULT performs matrix multiplication: each result is a row of the first array multiplied item by item with a column of the second, then added up.
In business terms it's a quick way to apply a price list to a quantity grid, or totals across many rows at once.
Syntax
=MMULT(array1, array2) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| array1 | Yes | The first matrix. Its number of columns must equal array2's rows. |
| array2 | Yes | The second matrix. |
Examples
Example 1 — Revenue per store
Units of three products sold in each store, times each product's price (E2:E4).
F2fx=MMULT(B2:D3, E2:E4)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Store | Widget | Gadget | Cable | Price | Revenue |
| 2 | Vancouver | 10 | 4 | 15 | 4.5 | 123 |
| 3 | Calgary | 6 | 8 | 5 | 12 | 133 |
| 4 | 2 |
=MMULT(B2:D3, E2:E4) Explain
Vancouver: 10×4.5 + 4×12 + 15×2 = 123. Calgary: 6×4.5 + 8×12 + 5×2 = 133.
Common mistakes
- Size mismatch. If array1's columns don't match array2's rows, MMULT returns #VALUE!.
Notes
- In older Excel, select the output range and press Ctrl+Shift+Enter.
- Related functions: SUMPRODUCT, MINVERSE, MDETERM, TRANSPOSE.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.