## What is MMULT Function in Excel?

The **MMULT **function is one of the math functions of Excel.

It Returns **the matrix product of two arrays**, an array with the **same number of rows** as array1 and **columns **as array2.

We can find this function in **Math & trig** category of insert function Tab.

## How to use MMULT function in excel

- Click on an
**empty cell**(like F5 ).

2. Click on **fx icon** (or press** shift+F3**).

3. In the **insert function tab** you will see all functions.

4. Select **math and trig** category.

5. Select **MMULT **function.

6. Then select **ok**.

7. In the function arguments Tab you will see ** MMULT **function.

8. **Array1** is the first array of numbers to multiply and **must have** the same number of columns as **Array2 **has rows.

9. **Array2 **is the second array of numbers to multiply and** must have** the same number of columns as **Array1 **has rows.

10. You will see **results **in the formula result section.

## Examples of **MMULT** function in Excel

**Example 1:**

**How to use MMULT function in excel**

You can see examples of MMULT function below:

```
=MMULT({1,2;3,4},{5,6;7,8})------->>>> answer is {19,22;43,50}
=MMULT({1,0;0,1},{0,1;1,0})------->>>> answer is {0,1;1,0}
=MMULT({1,2;2,1},{2,1;1,2})------->>>> answer is {4,5;5,4}
```

**Example 2:**

**How to count rows with specific value**?

By using MMULT function, we can count a specific record in the table.

For example, in the table below, How many people weigh more than 230 kg?

Name | Age | Height | Weight |

Olivia | 25 | 210 | 180 |

Noah | 25 | 205 | 235 |

Oliver | 27 | 195 | 205 |

Elijah | 22 | 198 | 185 |

James | 29 | 199 | 231 |

William | 29 | 201 | 240 |

Benjamin | 21 | 202 | 235 |

Lucas | 25 | 200 | 238 |

Henry | 22 | 204 | 190 |

`=SUM(--(D2:D10>230))---->>>>>answer is 5`

For example, in the table above, How many people weigh or Height is more than 200 kg?

```
=SUM(--(MMULT(--(B2:E10>200),TRANSPOSE(COLUMN(B2:E10)))>0))
answer is 8
```

## What is the purpose of **MMULT** function?

**MMULT**

It Returns **the matrix product of two arrays**, an array with the **same number of rows** as array1 and **columns **as array2 that sometimes called the “dot product”.

## What is the Return value of **MMULT** function?

**MMULT**

It returns an array of numbers.

`MMULT(array) = array`

## How many arguments does **MMULT** function have?

**MMULT**

This function has just **1** Argument.

The **argument **of MMULT function is **number**.

**Array1** is the first array of numbers to multiply and **must have** the same number of columns as **Array2 **has rows.

**Array2 **is the second array of numbers to multiply and** must have** the same number of columns as **Array1 **has rows.

The argument of MMULT function is **required **and not optional.

```
MMULT(number) = number
```

## Which version of excel supports **MMULT** function?

**MMULT**

This function is available for all excel **versions **(2003-2019).

## Errors in **MMULT** function

**MMULT**

MMULT returns the **#VALUE!** error when:

- Any cells are empty or contain text

`=MMULT({,2;3,4},{5,6;7,8})------->>>> answer is `**#VALUE!**
=MMULT({1,0;0,},{0,1;1,0})------->>>> answer is **#VALUE!**
=MMULT({1,2;,1},{2,1;1,2})------->>>> answer is **#VALUE!**

2. The number of columns in array1 is different from the number of rows in array2.

`=MMULT(A3:B4,D3:E3)------->>>> answer is `**#VALUE!**
=MMULT(A6:A7,D6:E7)------->>>> answer is **#VALUE!**
=MMULT(A9:B10,D9:E11)------->>>> answer is **#VALUE!**