title: How to do product of sum with Excel
body: <p><img src="https://i.stack.imgur.com/dThHU.jpg" alt="enter image description here"></p>
  
  <p>I would like to have the result by 1 formulas in the cell next to "TOTAL"</p>
  
  <p>Right now I have to:</p>
  
  <ol>
  <li><code>SUM(QTY1, QYT2, QTY3)*Price</code> on each row</li>
  <li><code>SUM</code></li>
  </ol>
  
  <p>Is there anyway to get the final result with 1 step something like <code>SUMPRODUCT(PRICE, SUM(QTY1,QTY2,QTY3))</code>?</p>