title: How to create different output with 4 conditions in excel using COUNTIF and COUNT?
body: <p>I am trying to create a formula which will display the following;</p>
  
  <p>if =>1 is NOK out of 10, overall is NOK</p>
  
  <p>if out of 10 is, =>1 but &lt;10 is OK, overalll is In Progress</p>
  
  <p>if out of 10 is, 10 is Not Started, overall is Not Started</p>
  
  <p>if out of 10, 10 is OK, overall is OK</p>
  
  <p>I used the following formula;</p>
  
  <pre><code>=IF(COUNTIF(K102:K111,"NOK"),"NOK",IF(COUNTIF(K102:K111,"OK")&gt;=1,"In Progress",IF(COUNT(COUNTIF(K102:K111,"Not Started")=10),"Not Started","In Progress")))
  </code></pre>
  
  <p>I can get the first 3 conditions correctly, but the last one, if 10 out of 10 is OK, i still get overall is "In Progress"</p>
  
  <p>Kindly help. Thank you~</p>