title: Excel Countifs shows error or returns 0 when multiple criteria is set
body: <p>I want to count the name of people if two of the criteria are matched, however, my code would either return "0" or will come with "#VALUE" error.
  I am trying the match how "Ron" with "Section 1" in a given range.</p>
  
  <p>My Code is:</p>
  
  <pre><code>=COUNTIFS(C1:F4,"*"&amp;A7, B1:B4,A6)
  </code></pre>
  
  <p>Below is my table, I didn't know how else to upload the table here.
  <a href="https://i.stack.imgur.com/wqUG2.png" rel="nofollow">Excel Page</a></p>