Description
Returns the matrix product of two arrays.
NOTE
- MMULT returns the #VALUE! error when:
- Any cells are empty or contain text.
- The number of columns in array1 is different from the number of rows in array2.
- The function may return an error when the array too large.
Syntax
Copied!=MMULT(array1, array2)
SAMPLE data
| | A | B | C | D |
|:---:|:----|:-----------|:----|:----|
| 1 | | | | |
|-----|-----|------------|-----|-----|
| 2 | | | | |
|-----|-----|------------|-----|-----|
| 3 | | 623abcd | | |
|-----|-----|------------|-----|-----|
| 4 | | 20def | | |
|-----|-----|------------|-----|-----|
| 5 | | 48034rewqe | | |
|-----|-----|------------|-----|-----|
| 6 | | | | |
|-----|-----|------------|-----|-----|
| 7 | | | | |
|-----|-----|------------|-----|-----|EXAMPLE 1
Copied!//𝘦𝘹𝘵𝘳𝘢𝘤𝘵 𝘯𝘶𝘮𝘣𝘦𝘳𝘴 𝘵𝘩𝘢𝘵 𝘢𝘱𝘱𝘦𝘢𝘳 𝘢𝘵 𝘵𝘩𝘦 𝘣𝘦𝘨𝘪𝘯𝘯𝘪𝘯𝘨 𝘰𝘧 𝘢 𝘴𝘵𝘳𝘪𝘯𝘨: =LET(T, B3:B5, X, MAX(LEN(T)), LEFT(T, MMULT(IFERROR((MID(T, TRANSPOSE(SEQUENCE(X)), 1)+1)^0, 0), SEQUENCE(X, , , 0))))
| | A |
|:---:|:------|
| 1 | 623 |
|-----|-------|
| 2 | 20 |
|-----|-------|
| 3 | 48034 |