title: How to count the number of times that a range does not match a cell
body: <p>I am trying to count the number of times that a range does not match a cell. </p>
  
  <p>For example: B5 can be "Yes" or "No" based on the selection from a Data Validation Table. I want the formula to count the number of times that C5:N5 do NOT match B5. So if B5 is "Yes", how many times in C5:N5 was "No" selected. And if B5 is "No", how many times in C5:N5 was "Yes" selected.</p>