title: VBA If Countifs
body: <p>I use the below to only instigate a certain piece of code if there is data,</p>
  
  <pre><code>If WorksheetFunction.CountIf(wksdata.Range("D:D"), "ASM001") &gt; 0 Then
  </code></pre>
  
  <p>However, I need it to work under a CountIfs as well, as some sheets have more than one criteria, such as the example below where it uses BIR001, BIR004, BIR006, ITI001. I need it to continue if there is at least 1 of ANY of them.</p>
  
  <pre><code>If WorksheetFunction.CountIfs(wksdata.Range("D:D"), "BIR001", wksdata.Range("D:D"), "BIR004", wksdata.Range("D:D"), "BIR006", wksdata.Range("D:D"), "ITI001") &gt; 0 Then
  </code></pre>
  
  <p>Can you help locate my error?</p>