title: excel COUNTIF formula
body: <p>I have a spread sheet with a colomn with the following formula copied down </p>
  
  <pre><code>=IF(L3 = "N/A","No Action",(IF((J3&lt;&gt;""),(IF((K3&lt;&gt;""),(IF((K3&gt;J3),"FALSE","TRUE")),"N/A")),"")))
  </code></pre>
  
  <p>which gives me the results below in colum "M"</p>
  
  <p>TRUE<br>
  TRUE 
  FALSE<br>
  No Action<br>
  N/A<br>
  N/A<br>
  No Action<br>
  N/A<br>
  N/A<br>
  No Action<br>
  No Action<br>
  No Action  </p>
  
  <p>So i used the following formula in another sheet </p>
  
  <p><code>=COUNTIF(Sheet1!M:M,"N/A")</code> which gives "4"<br>
  <code>=COUNTIF(Sheet1!M:M,"No Action")</code> gives "5"</p>
  
  <p>how ever <code>=COUNTIF(Sheet1!M:M,"FALSE")</code> or <code>=COUNTIF(Sheet1!M:M,"TRUE")</code></p>
  
  <p>Give the result "0"</p>
  
  <p>I think this is due to "TRUE and FALSE" being key words in excel but is there a way I can get excel to count the cells with these values in with out renaming them? </p>