title: How to get exact match in semi-complicated countifs() formula
body: <p>First, the formula I'm currently using:<p>
  <code>
  =countifs('page1'!AF:AF,$L6,'page1'!AA:AA,"="&amp;RIGHT(M$2,3))+countifs('page1'!AF:AF,$L6,'page1'!AB:AB,"="&amp;RIGHT(M$2,3))+countifs('page1'!AF:AF,$L6,'page1'!AC:AC,"="&amp;RIGHT(M$2,3))+countifs('page1'!AF:AF,$L6,'page1'!AD:AD,"="&amp;RIGHT(M$2,3))+countifs('page1'!AF:AF,$L6,'page1'!AE:AE,"="&amp;RIGHT(M$2,3))+countifs('page1'!AF:AF,$L6,'page1'!AF:AF,"="&amp;RIGHT(M$2,3))</code></p>
  
  <p>Alright, now, what I'm attempting to match against is:</p>
  
  <pre>
  I-A
  II-A
  III-A
  etc
  </pre>
  
  <p>The problem is that if within the ranges I'm looking there are patterns that loosely match the terms above, then the countifs() returns true without fully evaluating the entire string. In other words, I am specifically looking for strings "II-A" in said formula, but countifs() is returning counts for all strings that are not only "II-A" but "I-A" as well. Naughty countifs()!</p>
  
  <p>Is there an easy way to do this. I seriously do not want to have to rethink/rewrite these formulas. I found a method called exact() but rolling that in just seems painful. Any help would be much appreciated.</p>
  
  <hr>
  
  <h2>EDIT EDIT EDIT</h2>
  
  <p>Here's a test table...</p>
  
  <pre>
     A       B        C
  1 I-A   II-A    1-Jan
  2 II-A  III-A   2-Jan
  3 I-A   II-A    2-Jan
  4 I-A   II-A    3-Jan
  5 II-A  III-A   4-Jan
  6 I-A   II-A    7-Jan
  </pre>
  
  <p><code>
  =COUNTIFS($CC:$CC,"="&amp;$C2,$AA:$AA,"="&amp;$A1)+COUNTIFS($CC:$CC,"="&amp;$C2,$BB:$BB,"="&amp;$A1)
  </code></p>
  
  <p>This mock test formula results in 0, but what I'm looking for is 1, because one I-A occurs on 2-Jan...</p>
  
  <p>The same formula for 1-Jan should give me 1, and 1 for 3-Jan, and 7-Jan respectively. I'm trying to count the number of I-A, II-A, III-A for each date IE answering the question, "How many times does II-A occur on Jan-2, and then on Jan-3, etc?" Note that this is test data. The actual data actually has many more dates and many more kinds of values in place of the contents of the cells. For example purposes, however, this example data should be sufficient. </p>
  
  <p>Thanks! </p>