MMULT
Returns the matrix product of two arrays.
- Excel: Verified match
- Google Sheets: Verified match
- Returns: Array
Examples
=MMULT(A1:B2, G1:H2) | A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | 10 | 2 | 1 | 2 | ||||
| 2 | 20 | 4 | 3 | 4 |
Result 16
Syntax
MMULT(array1, array2)array1- range required
array2- range required
Errors
#VALUE!=MMULT(,)#ERROR!=MMULT(1)#NUM!=MMULT(A1, C1)