title: SUMIFS function having a sum range as a product of 2 ranges, Array Formulas
body: <p>I'm trying to minimize creating uneccessary tables in Excel, and instead of creating a table to multiply columns <code>A</code> and <code>B</code>, can I do it within the <code>IF</code> formula? Perhaps using Array formulas?</p>
  
  <p>I tried <kbd>Ctrl</kbd> + <kbd>Shift</kbd> + <kbd>Enter</kbd> to enter the following formula:</p>
  
  <pre><code>SUMIFS($A$1:$A$10*$B$1:$B$10,$C$1:$C$10,"Value")
  </code></pre>
  
  <p>however it did not work.</p>
  
  <p>Basically, I want to sum the product of <code>A</code> &amp; <code>B</code> (i.e <code>A*B</code>) if the value in <code>C</code> is equal to <code>"value"</code>.</p>