title: Count number of cells that match criteria with nested IF and COUNTIF statements
body: <p>I'm trying to use an excel formula to count the number of cells in a given range (let's say T132:T134) that match a specific line of text, however cells should only be counted if in a different range (say F132:F134) the corresponding cell in the same row is different from a specific line of text. Here is what I am trying to do:</p>
  
  <pre><code>=IF(T132:T134&lt;&gt;"Not applied";COUNTIF(F132:F134;"*WN(1)*"))
  </code></pre>
  
  <p>which should count the number of cells in the range F132:F134 that are equal to "<em>WN(1)</em>" only if the corresponding cell in the range T132:T134 is different from "Not applied". However this does not work, but if I apply the same expression to specific cells it works without any problem, as follows:</p>
  
  <pre><code>=IF(T134&lt;&gt;"Not applied";COUNTIF(F134;"*WN(1)*"))
  </code></pre>
  
  <p>Is there any way to apply this principle to a range of cells, such as the one in the example that does not work?</p>