MMULT function
This article describes the formula syntax and usage of the MMULT function in Microsoft Excel.
Description
Returns the matrix product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2.
Syntax
MMULT(array1, array2)
The MMULT function syntax has the following arguments:
-
Array1, Array2 Required. The arrays you want to multiply.
Remarks
-
The number of columns in Array1 must be the same as the number of rows in Array2, and both arrays must contain only numbers.
-
Array1 and Array2 can be given as cell ranges, array constants, or references.
-
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 matrix product array a of two arrays b and c is:
where i is the row number, and j is the column number.
-
Formulas that return arrays must be entered as array formulas.
Note: In Excel Online you cannot create array formulas.
Examples
Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.
Array 1 | Array 1 | ||
1 | 3 | ||
7 | 2 | ||
Array 2 | Array 2 | ||
2 | 0 | ||
0 | 2 | ||
Formula | Description | Results | |
'=MMULT(A2:B3,A5:B6) | The results should be 2, 14, 6, and 4, in cells C8, C9, D8, and D9. | =MMULT(A2:B3,A5:B6) | =MMULT(A2:B3,A5:B6) |
=MMULT(A2:B3,A5:B6) | =MMULT(A2:B3,A5:B6) |
Note: To work correctly, the formula in the example needs to be entered as an array formula in the Excel program. After copying the example to a blank worksheet, select the range C8:D9 starting with the formula cell. Press F2, and then press Ctrl+Shift+Enter. If the formula is not entered as an array formula, a single result (2) will be returned in cell C8.
Example 2
Customer | Product Qty | ||
Corks | Bottles | Barrels | |
Contoso, Ltd. | 14 | 9 | 3 |
Coho Winery | 2 | 11 | 15 |
Price | Weight (lbs) | Product | |
$200 | 4 | Corks (500/box) | |
$250 | 42 | Bottles (case) | |
$425 | 115 | Barrel | |
Customer | Sales | Total weight | |
Contoso, Ltd. | =MMULT(B3:D4,A8:B10) | =MMULT(B3:D4,A8:B10) | =MMULT(B3:D4,A8:B10) |
Coho Winery | =MMULT(B3:D4,A8:B10) | =MMULT(B3:D4,A8:B10) | =MMULT(B3:D4,A8:B10) |
=MMULT(B3:D4,A8:B10) | =MMULT(B3:D4,A8:B10) | =MMULT(B3:D4,A8:B10) |
Note: The formula in B13:D15 needs to be entered as an array formula to work correctly.
No comments:
Post a Comment