Formulas > =MMULT()

How To Use MMULT() Function in Google Sheets


Calculates the matrix product of two matrices specified as arrays or ranges.

Common questions about the MMULT Formula include:

• How does the MMULT formula work?
• How is it used to multiply two matrices or vectors together?
• What is the syntax for the MMULT formula?
• How can I use array formulas with MMULT?

The MMULT formula can be used appropriately for multiplying two matrices or vectors together. It can also be used with array formulas to perform multiplications with multiple criteria.

The MMULT formula is commonly mistyped as MULT, MULTIPLY, or MMULTIPLY.

Some common ways the MMULT formula is used inappropriately include using it to add two matrices or vectors, trying to use MMULT with a numerical argument, or attempting to use it as a lookup function.

Common pitfalls when using the MMULT formula include making sure both matrices or vectors have the same dimensions, checking that each variable has the correct data type, and using the array option with a function.

Common mistakes when using the MMULT Formula include forgetting to wrap the formula in braces or using the incorrect order of arguments.

Common misconceptions people might have with the MMULT Formula include thinking it is used as a lookup function, not understanding what a Matrix is, or thinking it is used to add two matrices.

How To Actually Use MMULT() in Sheets

MMULT(matrix1, matrix2)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the MMULT() formula:

Generate a MMULT() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.