title: Count matches between two columns
body: <p>In Excel, I have two columns. One is a prediction, one is the result. I want to count how many times the prediction matches the result (i.e. a correct prediction).</p>
  
  <p>The data is like so:</p>
  
  <pre><code>Col A      Col B
  Bears      Bears
  Chiefs     Raiders
  Chargers   Chargers
  Colts      Texans
  Lions
  Packers
  </code></pre>
  
  <p>So the number I want to get to via a formula is <b>2</b>, since that's how many matches there were (Bears and Chargers). Keep in mind the match has to be in the <b>same row</b>.</p>
  
  <p>Thanks.</p>