MMULT
TheMMULT
formula in Google Sheets multiplies two matrices together and returns the resulting matrix. It is commonly used in linear algebra for matrix multiplication.
 How to use
MMULT
formula?  Examples of using
MMULT
formula MMULT
formula not working? Similar formulas to
MMULT
Usage
Use the MMULT
formula with the syntax shown below, it has 2 required parameters:
 matrix1 (required):
The first matrix to be multiplied. Must contain at least one row and one column.  matrix2 (required):
The second matrix to be multiplied. Must have the same number of rows as the number of columns in matrix1.
Examples
Here are a few example use cases that explain how to use theMMULT
formula in Google Sheets.
Multiply two matrices
The MMULT
formula can be used to multiply two matrices together and return the resulting matrix.
Calculate linear transformations
Linear transformations can be represented using matrices, and the MMULT
formula can be used to calculate the resulting matrix of applying multiple linear transformations to a vector.
Common Mistakes
MMULT
not working? Here are some common mistakes people make when using the MMULT
Google Sheets Formula:
Incorrect matrix dimensions
One of the most common mistakes when using the MMULT formula is providing matrices with incorrect dimensions. The number of columns of the first matrix must match the number of rows of the second matrix. Doublecheck your matrices' dimensions and adjust them if necessary.
Not using curly braces to input matrices
When inputting matrices, make sure to enclose them in curly braces and separate rows by semicolons. Avoid using parentheses or brackets, as they will not work with the MMULT formula.
Using nonnumeric values
The MMULT formula only works with numeric values. Make sure your matrices contain only numbers and avoid using any other characters or symbols.
Forgetting to specify both matrices
The MMULT formula requires two matrices as inputs. Make sure you have specified both matrices and that they are separated by a comma.
Incorrect order of matrices
The order of matrices matters for the MMULT formula. The first matrix should be the one with the same number of columns as the second matrix's number of rows. Doublecheck that you have entered the matrices in the correct order.
Related Formulas
The following functions are similar to MMULT
or are often used with it in a formula:

SUMPRODUCT
The
SUMPRODUCT
formula in Google Sheets multiplies corresponding values in the specified arrays and returns the sum of those products. It is commonly used to find the weighted average or to perform a dot product calculation. 
TRANSPOSE
The
TRANSPOSE
formula in Google Sheets allows you to flip a table of data by turning rows into columns and columns into rows. This can be useful for reorganizing data or preparing it for use in other formulas. 
MINVERSE
The
MINVERSE
function in Google Sheets returns the inverse matrix of a given square matrix. The inverse matrix is such that when multiplied by the original matrix, it results in an identity matrix. This function is commonly used in linear algebra, such as solving systems of linear equations or finding determinants of matrices.
Learn More
You can learn more about the MMULT
Google Sheets function on Google Support.