title: Excel Formula returning Unexpected Results
body: <p>Formula in question:</p>
  <p><code>=IF(AND(COUNTIF(Roster[Number],[@Number]),COUNTIF(Roster[Black List],&quot;TRUE&quot;)),&quot;TRUE&quot;,&quot;FALSE&quot;)</code></p>
  <p>The idea here is to check if any row is &quot;black listed&quot; on one table by comparing the &quot;Number&quot; columns on it and the Roster. The &quot;Black List&quot; column on the Roster is generated by checking two other columns on the Roster:</p>
  <p><code>=IF(OR([@Quarantined]=&quot;TRUE&quot;,[@[Leave In Place]]=&quot;TRUE&quot;),&quot;TRUE&quot;,&quot;FALSE&quot;)</code></p>
  <p>The problem is that no matter what I seem to do, the initial formula returns &quot;FALSE&quot; for all rows checked even though the Roster contains exact matches of the Numbers and a value of &quot;TRUE&quot; in the Black List column.</p>
  <p>Am I missing something simple here?</p>