MMULT function

MMULT calculates the array product of two arrays.


The number of columns for the first array must match the number of rows for the second array. The square array has an equal number of rows and columns.

MMULT (array1,array2)

  • array1 as the first argument represents the first array with a specific number of columns.
  • array2 as the second argument represents the second array with the number of rows the same as the number of columns in the first array.


Choose the MMULT function. Select the first array, add a comma after the range values that are added to the formula, and then select the second array. Press Enter. The output array will appear in the first selected range.