title: Google Spreadsheet, Count IF contains a string
body: <p>I have a column like this: </p>
  
  <p>What devices will you be using? </p>
  
  <pre><code>iPad
  Kindle &amp; iPad
  No Tablet
  iPad
  iPad &amp; Windows
  </code></pre>
  
  <p>How do I count the amount of people that said iPad?</p>
  
  <p>This formula does work for exact matches but not if it contains an additional value: </p>
  
  <pre><code>=(COUNTIF(A2:A51,"=iPad")/COUNTA(A2:A51))*1
  </code></pre>
  
  <p>Any Suggestions?</p>