title: Counting cells that contain a certain bit of text without duplicates
body: <p>I need to count the number of cells in a column that contain a certain bit of text. Actually, I will be doing multiple of these counts, and I need to remove the duplicates.</p>
  
  <p>Example info:<br>
  Lala<br>
  Lerly PTY LTD<br>
  Trang AS TTE<br>
  Trerek AS TTE<br>
  PRING PTY LTD AS TTE<br>
  Treps PTY LTD<br>
  Liang AS TTE<br>
  Praderpis PTY LTD AS TTE</p>
  
  <p>I need to count the amount of times "AS TTE" shows up, and also the amount of times "PTY LTD" shows up. However, I only want to count the cells that contain both "AS TTE" and "PTY LTD" once.</p>
  
  <p>I have this so far:</p>
  
  <pre><code>(COUNTIF(F4:F1000,"*AS TTE*") + COUNTIF(F4:F1000, "*PTY LTD*"))
  </code></pre>
  
  <p>However this counts duplicates.  </p>
  
  <p>edit: I should clarify, my uses for this are much more complicated than what I have listed, so it isn't as easy as simply subtracting another COUNTIF that has the both of them. I have many other COUNTIFs I will be doing.</p>