title: How to execute sumproduct with two criteria?
body: <p>I need to create a formula in excel that returns the sum-product of two columns in a range, based on two conditions.
  Considering a table of 4 columns (A;B;C;D), if any row in column A is equal to a given value (example=&quot;A&quot;) and any row in column B starts with &quot;*&quot;, then multiply column C and D and sum these products.
  Any suggestions on how to implement the formula?</p>
  <p>I thought it could be the following formula but it doesn't work:</p>
  <pre><code>=SUMPRODUCT(--(A2:A12=&quot;A&quot;); --(left(B2:B12;1)=&quot;*&quot;); C2:C12; D2:D12)
  </code></pre>