# Google Sheets MMULT Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/mmult-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The MMULT function multiplies two arrays or matrices, returning the sum of products for corresponding elements, useful for linear algebra calculations. ``` MMULT(matrix1, matrix2) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the MMULT you need in plain EnglishGenerate Formula ## Parameters **`matrix1`**:\ The first array or range of cells that you want to multiply. This matrix must have the same number of columns as the number of rows in the second matrix. **`matrix2`**:\ The second array or range of cells that you want to multiply. This matrix must have the same number of rows as the number of columns in the first matrix. ## What is an MMULT? The *MMULT* function in Google Sheets is a powerful tool used to perform matrix multiplication. It takes two arrays (or ranges) as input and returns the product of those matrices. This function is particularly useful in various mathematical, statistical, and engineering applications where matrix operations are required. In simpler terms, MMULT allows you to multiply two sets of numbers arranged in rows and columns, providing a new set of numbers as a result. ## A Practical Example Imagine you are analyzing sales data for different products across various regions, and you have the following matrices: ### Sales Matrix: | Region | Product A | Product B | | - | - | - | | North | 10 | 20 | | South | 30 | 40 | ### Price Matrix: | Product | Price | | - | - | | Product A | 5 | | Product B | 10 | You want to calculate the total sales revenue for each region based on the number of products sold and their prices. ## MMULT Formula To achieve this, you would use the MMULT function as follows: ``` =MMULT(Sales!B2:C3, Prices!B2:B3) ``` In this formula: - `Sales!B2:C3` is the range containing the sales data for Product A and Product B. - `Prices!B2:B3` is the range containing the prices for Product A and Product B. ## Result of the Formula When you apply the MMULT formula, the output would look like this: | Region | Total Revenue | | - | - | | North | 250 | | South | 550 | In this case, the total revenue for the North region is calculated as (10 \* 5) + (20 \* 10) = 250, and for the South region, it is (30 \* 5) + (40 \* 10) = 550. ## Why Use MMULT? MMULT is beneficial because it simplifies the process of performing matrix operations in Google Sheets. It allows for efficient calculations without the need for manual multiplication and summation of individual elements. This function is particularly useful in financial modeling, data analysis, and any scenario where matrix mathematics is required. ## Key Takeaways: - **MMULT**: A Google Sheets function that performs matrix multiplication on two arrays. - **Efficient**: Simplifies complex calculations by automating the multiplication and summation process. - **Versatile**: Useful in various fields such as finance, engineering, and data analysis. - **Common Use Cases**: Ideal for calculating revenues, analyzing data sets, and performing statistical operations. MMULT is an essential function for anyone working with numerical data in Google Sheets, providing a powerful way to enhance data analysis and reporting capabilities. Happy spreadsheeting! ## Example use case You have a table with sales data where Column A lists products and Columns B and C contain sales figures for two different regions. Use the MMULT formula to calculate total sales for each product across both regions, streamlining your sales analysis. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Enable Macros In Google Sheets](https://betteranalyst.com/google-sheets/how-to-enable-macros-in-google-sheets) - [How To Filter In Google Sheets](https://betteranalyst.com/google-sheets/how-to-filter-in-google-sheets) - [How To Find Circular References In Google Sheets](https://betteranalyst.com/google-sheets/how-to-find-circular-references-in-google-sheets) - [How To Find Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-find-duplicates-in-google-sheets) - [How To Freeze A Row In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-a-row-in-google-sheets) - [How To Freeze Panes In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-panes-in-google-sheets) - [How To Highlight Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-highlight-duplicates-in-google-sheets) - [How To Insert Checkbox In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-checkbox-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.