title: sumproduct Formula array in VBA
body: <pre><code>ActiveSheet.Evaluate("=SUMPRODUCT((""" &amp; Source1_Val &amp; """ = " &amp; Target1 &amp; ")*(""" &amp; Source2_Val &amp; """ = " &amp; target2 &amp; ")*ROW(" &amp; Target1 &amp; "))")
  </code></pre>
  
  <p>The same formula works when I directly put in Excel but when done throught VBA I am not getting any result.</p>
  
  <p>Excel formula:</p>
  
  <pre><code>=SUMPRODUCT((Source!Q2=Q1:Q33)*(Source!L2 = L1:L33)*ROW(L1:L33))
  </code></pre>