title: COUNTIFS and 2 Dimensional Array
body: <p>I have a table full of information in the following format:</p>
  
  <p><img src="https://i.stack.imgur.com/Andf6.png" alt="">         </p>
  
  <p>I made a table that tries to create a relationship between the columns; for example, the number of people in Support that are also in Security (should return 2)</p>
  
  <p>As a formula, I wrote the following</p>
  
  <blockquote>
    <p>COUNTIFS($A$2:$AA$49,$A53,$A$2:$AA$49,D$52)</p>
  </blockquote>
  
  <p>Where <em>$A$2:$AA$49</em> is the range of the whole data, and <em>$A53</em> and <em>D$52</em> is the condition it should equate to.</p>
  
  <p>Yet, no matter what I try, I always yield 0, stating I'm referring to a blank cell.</p>
  
  <p>The following is the format I want to place it in. Assume <em>$A53</em> and <em>D$52</em> are Support and Implementation, respectively.</p>
  
  <p><img src="https://i.stack.imgur.com/sHthL.png" alt=""></p>