title: Calculate range and exclude some text
body: <p>I am trying to calculate data from Sheet1 onto Sheet2.  Part of my calculation, I need to work out how many tasks I have within a 5-10 day deadline (which I can get from Column A{A1:A501}) but I also need it to exclude the tasks that have the word PINK which is in a separate Column C{C1:C501}. 
  The calculation I have so far is:  </p>
  
  <pre><code>=COUNTIF(Sheet1!A1:A501,"&lt;="&amp;10)-COUNTIF(Sheet1!A1:A501,"&lt;"&amp;5)
  </code></pre>