I have a spread sheet of (36x1) with matrix (1x15). I want to calculate a matrix value. I use Microsoft Excel 2016. My coding is =MMULT(A1:Z1 B5:19). The answer is you input too view arguments of this function. I think I have made a wrong calculation. But it clear I follow from the website or other person who can calculate the matrix. Is there any one can help?

4 Answers 4


Select the output range. Input the formula:


Then press the keys [Ctrl] + [Shift] + [Enter]


I follow your suggestion and the answer is enter image description here. I don't know why?


I send you again my figure. It seems not to difficult to formulate MMULT, but it still doesn't work. Cam yout tell me how to calculate in manual mannner? enter image description here

  • In your formula, there should be a comma instead of a semicolon between the two parameters. If you want to get a multiple result, you need to select multiple cells and press {[Ctrl] + [Shift] + [Enter]}. Please refer to the links from my answer.
    – Bella
    Aug 21, 2019 at 9:24

It seems that you enter the wrong format of MMULT() formula. The right format is "=MMULT(array1, array2)". Maybe you should input the formula:


Please refer to MMULT function and Create an array formula that calculates a multiple result.

Note that you need to select multiple cells and press [Ctrl] + [Shift] + [Enter]. For example:

enter image description here

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .