title: countifs with an or statement - excel
body: <p>I have a workbook where im referencing another workbook to count a certain number of items.</p>
  
  <p>conditions:
  1) col B has 11103,11104, or 11105 in it,
  2) col F contains /2A DT</p>
  
  <p>everything works fine if i just put 11103 in it, ive tried different permutations of the OR statement but cant find to find one that works, any suggestions? below is the formula:</p>
  
  <pre><code>=COUNTIFS('[all schools nfer log.xlsx VERSION 2.xlsx]Sheet1'!$B:$B,OR('[all schools nfer log.xlsx VERSION 2.xlsx]Sheet1'!$B:$B=11103,'[all schools nfer log.xlsx VERSION 2.xlsx]Sheet1'!$B:$B=11104,'[all schools nfer log.xlsx VERSION 2.xlsx]Sheet1'!$B:$B=11105),'[all schools nfer log.xlsx VERSION 2.xlsx]Sheet1'!$F:$F,"/2A DT")
  </code></pre>