I’m trying to perform a matrix multiplication in Google Sheets.

By /

Matrix multiplication in Google Sheets is a quick and easy way to perform a matrix multiplication. To do this, you must select the range of cells to be multiplied, select the matrix multiplication command, and then enter the number of rows and columns for each matrix. The result of the multiplication will then be displayed in the designated cell range. This can be done quickly and easily, making it great for complex calculations.

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:

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:

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:

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

x

Related terms:

  1. How can i Perform Matrix Multiplication in Excel (With Examples)
  2. How to do matrix multiplication?
  3. How to Create a Correlation Matrix in Google Sheets
  4. How to Create a Covariance Matrix in Google Sheets
  5. What is the general multiplication rule?
  6. Count Specific Characters in Google Sheets How to count specific characters in google sheets?
  7. I am trying to use an IF Function with 4 Conditions. What is the formula I should use?
  8. How to Fix You are trying to merge on object and int64 columns?
  9. How do I perform a Reverse VLOOKUP in Google Sheets?
  10. How to Perform a Median IF Function in Google Sheets?