title: Excel, Calculate Sum of one column where the corresponding row in another column equals a value
body: <p>So I have the following formula which works perfectly to calculate the SUM of an entire column of another worksheet which I reference indirectly.</p>
  
  <pre><code>=SUM(INDIRECT(A4&amp;"!C:C"))
  </code></pre>
  
  <p>What I need now is to calculate the SUM of C (as above) but only when the relevant row in Column D is equal to Yes.</p>
  
  <p>Can this be done?</p>
  
  <p>Thanks,</p>