title: Countifs: Need to count number of cells 12 months prior to given date in a range
body: <p>I had a data set, say "ORANGE" from <code>12/1/2010</code> to <code>12/1/2019</code>.</p>
  
  <pre><code> A        B             C-FIND
  1 org   12/01/2016      09/05/2018
  2 org   08/05/2017
  3 org   01/07/2018
  4 org   12/03/2019
  5 apple 11/03/2017
  6 apple 9/9/2018
  </code></pre>
  
  <p>To find:  </p>
  
  <p>Find number of "ORANGES" 12 months prior to the given date, say `09/05/2018(MENTIONED IN CELL C1).</p>
  
  <p>This is what I tried:</p>
  
  <pre><code>=COUNTIFS($A$2:$A$12807,"ORANGES",$B$2:$B$12807,"&lt;=" &amp; C1)
  </code></pre>