How to Perform Matrix Multiplication in Google Sheets


You can use the MMULT function in Google Sheets to perform matrix multiplication.

This function uses the following basic syntax:

MMULT(matrix1, matrix2)

where:

  • matrix1, matrix2: The two matrices you’d like to multiply.

The following examples show how to use the MMULT function to perform the following matrix multiplications in Google Sheets:

  • (2×2) by (2×2) Matrix Multiplication
  • (2×2) by (2×3) Matrix Multiplication
  • (3×3) by (3×2) Matrix Multiplication

Let’s jump in!

Example 1: (2×2) by (2×2) Matrix Multiplication

The following screenshot shows how to multiply a (2×2) matrix with another (2×2) matrix in Google Sheets:

2x2 by 2x2 matrix multiplication in Google Sheets

We typed the following formula in cell G2 to perform this matrix multiplication:

=MMULT(A2:B3, D2:E3)

Here are the actual formulas that Google Sheets used to perform this matrix multiplication:

This results in the following 2×2 matrix:

Related: An Introduction to (2×2) by (2×2) Matrix Multiplication

Example 2: (2×2) by (2×3) Matrix Multiplication

The following screenshot shows how to multiply a (2×2) matrix with a (2×3) matrix in Google Sheets:

2x2 by 2x3 matrix multiplication in Google Sheets

We typed the following formula in cell H2 to perform this matrix multiplication:

=MMULT(A2:B3, D2:F3)

Here are the actual formulas that Google Sheets used to perform this matrix multiplication:

This results in the following 2×3 matrix:

Related: An Introduction to (2×2) by (2×3) Matrix Multiplication

Example 3: (3×3) by (3×2) Matrix Multiplication

The following screenshot shows how to multiply a (3×3) matrix with a (3×2) matrix in Google Sheets:

3x3 by 3x2 matrix multiplication in Google Sheets

We typed the following formula in cell H2 to perform this matrix multiplication:

=MMULT(A2:C4, E2:F4)

Here are the actual formulas that Google Sheets used to perform this matrix multiplication:

This results in the following 3×2 matrix:

Related: An Introduction to (3×3) by (3×2) Matrix Multiplication

Note: You can find the complete documentation for the MMULT function in Google Sheets here.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Use a MULTIPLY IF Function in Google Sheets
How to Multiply Column by a Constant in Google Sheets
How to Multiply Column by a Percentage in Google Sheets

Leave a Reply

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