Google Sheets | MMULT Function | Matrix Multiplication | Example | Spreadsheet | Tutorial

Published: 24 February 2026
on channel: Software Spring

An use of the Google Sheets MMULT function is calculating the total stock portfolio value on any day. MMULT stands for matrix multiplication. This function requires two matrices as its arguments.

It is important to ensure that the number of columns in the first matrix equals the number of rows in the second matrix. Otherwise, the MMULT function will return an error.

*************************************
How to Create a Simple Balance Sheet in Google Sheets?

Gives the steps to create a simple balance sheet and ledgers:

   • Google Sheets | How to Create a Simple Bal...
*************************************

*************************************
Which to Use: XLOOKUP or VLOOKUP to Extract Data in Google Sheets?

Which of these two functions is more powerful and versatile? Watch this video for an answer:

   • Google Sheets | XLOOKUP | VLOOKUP | Functi...
*************************************

-------------------------------------
How to Create a Pivot Table in Google Sheets?

Create a pivot table for calculation and in-depth data analysis:

   • Google Sheets | Pivot Table | How to Creat...
-------------------------------------
How to Use Convert to Table in Google Sheets?

Convert a data range into a table easily:

   • Google Sheets | Convert to Table | Change ...
-------------------------------------
How to Use SCAN in Google Sheets?

It's easy to calculate running total, running count and the like with SCAN:

   • Google Sheets | SCAN | Function | Calculat...
-------------------------------------
How to Use COUNTIFS in Google Sheets?

Count values that fulfill one or more criteria:

   • How to use COUNTIFS in Google Sheets | COU...
-------------------------------------

MMULT Function Formula

=MMULT(matrix1, matrix2)

matrix1 is the first matrix or an array.

matrix2 is the second matrix or an array.

Example

Let's consider a real-world application of the MMULT function formula:

Assume that you have a portfolio of shares of three companies, whose symbols are Infy, ITC, and PFC. The quantity of shares held in each of these three companies are 7, 38, and 12 respectively.

Say you want to calculate the total portfolio value, say on 3rd, 4th and 5th days of a month.

Assume that the quantity of shares is in the range B3 to B5 and prices of the three shares are in the range E3 to E5.

The MMULT function formula for this task is:

=MMULT(E3:G5,B3:B5)

The function will return the total stock portfolio value.

Please watch this video tutorial, which gives the steps to use the Google Sheets MMMULT function to calculate the total stock portfolio value on any day, with examples.

On this page of the site you can watch the video online Google Sheets | MMULT Function | Matrix Multiplication | Example | Spreadsheet | Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Software Spring 24 February 2026, share the link with friends and acquaintances, this video has already been watched 73 times on youtube and it was liked by 1 viewers. Enjoy your viewing!

6,514

539