title: Count if two criteria match - EXCEL formula
body: <p>I have this table and I would like to create a formula which would count values based on true conditions from column <code>A</code> <em>and</em> column <code>C</code>. </p>
  
  <p>Example:
  If in column <code>A</code> value is M (male), and in column <code>C</code> is YES, then it would count. </p>
  
  <p>could anyone help me with this formula?</p>
  
  <p><img src="https://i.stack.imgur.com/JFfmB.png" alt="table"></p>