title: Excel VBA store countifs for multiple or conditions
body: <p>I am using VBA Countifs to get the count of certain values according to the condition. Now I need either condition to count. </p>
  
  <p>The below code work for count "No Video" rows and Non "No video" rows. But I want to count "No Video" or "No Data" as single output and another is without those two.</p>
  
  <pre><code> Set R1 = appExcel.Range(cmdAudit2.Text &amp; ":" &amp; cmdAudit2.Text)
   Set R2 = appExcel.Range(cmbChoice.Text &amp; ":" &amp; cmbChoice.Text)
  
   NoVideos = appExcel.Application.CountIfs(R1, AuditType, R2, "No video")
   Videos = appExcel.Application.CountIfs(R1, AuditType, R2, "&lt;&gt;No video")
  </code></pre>
  
  <p>I found some examples which using multiple conditions "and" operator. But I want "or" condition.</p>
  
  <p>For the time being I am using the below code to make it work</p>
  
  <pre><code> NoVideos = appExcel.Application.CountIfs(R1, AuditType, R2, "No video")
   NoAudited = appExcel.Application.CountIfs(R1, AuditType, R2, "Not audited")
   Videos = appExcel.Application.CountIfs(R1, AuditType, R2, "&lt;&gt;No video")
  
   Videos = Val(Videos) - Val(NoAudited)
   NoVideos = Val(NoVideos) + Val(NoAudited)
  </code></pre>
  
  <p>Is there any good method which can be done in with single countifs.</p>