MMULT Function in Excel: Multiply Matrices

MMULT Function in Excel: Multiply Matrices featured illustration

📎 This article includes 1 downloadable practice file ↓

⏱ 2 min readUpdated 28 September 2026

MathLevel: ExpertAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. MMULT in practice
  5. Where you will use it
  6. Worked example
  7. Mistakes people make
  8. Related functions
  9. Continue learning

MMULT multiplies two matrices. In practice it computes many weighted sums at once — quantities × price lists for many orders.

Advertisement

Syntax

=MMULT(array1, array2)
Argument What it means
array1 Columns must equal array2’s rows.

Examples

Example 1

=MMULT(B2:D50, G2:G4)

Order value for 49 orders × 3 products with prices in G2:G4.

MMULT in practice

Where you will use it

  • Quantity × price for many products and stores
  • Matrix calculations
  • Weighted scores

Worked example

CaseFormulaResult
1=ARRAYTOTEXT(MMULT(CHOOSE(A2,{2,3},{1,2;3,4},{1,0;0,1}),CHOOSE(A2,{10;20},{5;6},{7;8})))80
2=ARRAYTOTEXT(MMULT(CHOOSE(A3,{2,3},{1,2;3,4},{1,0;0,1}),CHOOSE(A3,{10;20},{5;6},{7;8})))17, 39
3=ARRAYTOTEXT(MMULT(CHOOSE(A4,{2,3},{1,2;3,4},{1,0;0,1}),CHOOSE(A4,{10;20},{5;6},{7;8})))7, 8

Results calculated in Excel.

Mistakes people make

MistakeWhat to do instead
Size mismatchColumns of the first must equal rows of the second
Using * instead* multiplies element by element

SUMPRODUCT · MINVERSE

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

⚡ Interactive Practice Lab & Formula Tester:

Test formulas dynamically in our web formula laboratory or download the companion Excel workbook.

Continue learning

All Math & Trig guides →
RANDARRAY Function in Excel: A Whole Grid of Random NumbersRANDARRAY returns an array of random numbers, optionally whole numbers between limits — instant…PERCENTOF Function in Excel: Share of the TotalPERCENTOF returns a subset’s share of a total — mostly used inside GROUPBY and…RAND Function in Excel: Random Decimal Between 0 and 1RAND returns a new random number between 0 and 1 on every recalculation —…RANDBETWEEN Function in Excel: Random Whole Numbers for Test DataRANDBETWEEN returns a random integer between two numbers. It recalculates on every change —…

📎 Practice files for this article

  • 📗
    Practice workbook: Math & rounding24 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.
    ⬇ XLSX · 35 KB

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.

✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong