MMULT function - Zoho Sheet - Help Guide

MMULT

Returns the product of two matrices given as arrays or ranges. Returns an array with an equal number of rows as array1 and an equal number of columns as array2.

 

Syntax

 

MMULT(array1; array2)

array1: The first matrix to multiply given as an array or range. E.g. A2:B5

array2: The second matrix to multiply given as an array or range. E.g. B2:C3  

Remarks

  • The number of columns in array1 must be equal to the number of rows in array2.


Examples

 

Formula

Result

=MMULT(A2:B5;B2:C3)

12

13

30

7

11

14

30

6

 

=MMULT(A2:C4;A2:C4)

37

18

54

36

19

54

27

18

46


Get a hands-on experience of the function in the embedded range below.    



Possible Errors

 

Errors

Meaning

#N/A!

  • The function could not find the value it was asked to look for. Commonly occurs in VLOOKUP and similar functions.

#NAME!

  • The function name is incorrect or invalid.

  • The given defined name (if any) is invalid.

  • There is a typo in the defined name used in the function.

  • Double quotes are missing for text values in the function.

  • Colon missing in a cell range reference.

#VALUE!

  • The given argument's data type is incorrect or invalid.
    For example, the function =DATE(A1:A3) will return a #VALUE error when a text value is present in the range.

#REF!

  • The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over.

 

Similar Functions