title: Dot product between row vectors by MMULT not working in Excel
body: <p>I am using Excel to do some dot product between two row vectors:</p>
  
  <pre><code>=MMULT(B1049:M1049, TRANSPOSE(B1050:M1050))
  </code></pre>
  
  <p>But it does not work, as the cell for the formula shows "#VALUE!". I wonder why? Thanks!</p>
  
  <p>Note that all the cells in "B1049:M1049" and "B1050:M1050"  are numbers.</p>
  
  <p>PS: Is this question more suitable here or Superuser?</p>