Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Find closest match in Excel
  • Extract all partial matches in Excel
  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • Merge tables with VLOOKUP in Excel
  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation

Data Analysis Examples

  • Excel Pie Chart
  • How To Insert and Customize Sparklines in Excel
  • How to count table rows in Excel
  • How to create Checklist in Excel
  • How to conditionally sum numeric data in an Excel table using SUMIFS

Data Validation Examples

  • Excel Data validation whole percentage only
  • Excel Data validation specific characters only
  • Excel Data validation allow uppercase only
  • Excel Data validation no punctuation
  • Excel Data validation must contain specific text

MMULT function: Description, Usage, Syntax, Examples and Explanation

by

What is MMULT function in Excel?

MMULT function is one of the Math and Trig functions in Microsoft Excel that returns the matrix product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2.

Worked Example:   Count rows with at least n matching values

Syntax of MMULT function

MMULT(array1, array2)

The MMULT function syntax has the following arguments:

  • Array1, Array2: The arrays you want to multiply.

MMULT formula explanation

  • The number of columns in Array1 must be the same as the number of rows in Array2, and both arrays must contain only numbers.
  • Array1 and Array2 can be given as cell ranges, array constants, or references.
  • MMULT returns the #VALUE! error when:
    • Any cells are empty or contain text.
    • The number of columns in Array1 is different from the number of rows in Array2.
  • The matrix product array a of two arrays b and c is:where i is the row number, and j is the column number.
  • Formulas that return arrays must be entered as array formulas.

Post navigation

Previous Post:

ABS function: Description, Usage, Syntax, Examples and Explanation

Next Post:

TANH function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to count specific words in a range in Excel
  • How to extract domain name from URL in Excel
  • SEARCH, SEARCHB functions: Description, Usage, Syntax, Examples and Explanation
  • How to strip numeric characters from cell in Excel
  • How to count specific words in a cell in Excel
  • Add workdays to date custom weekends in Excel
  • How to calculate quarter from date in Excel
  • How to get workdays between dates in Excel
  • DAY function: Description, Usage, Syntax, Examples and Explanation
  • Pad week numbers with zeros in Excel
  • ACCRINT function: Description, Usage, Syntax, Examples and Explanation
  • Calculate cumulative loan principal payments in Excel
  • RECEIVED function: Description, Usage, Syntax, Examples and Explanation
  • IRR function: Description, Usage, Syntax, Examples and Explanation
  • How to Calculate Tax Rates in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles