title: COUNTIF running into problems with DataTypes
body: <p>Basically I want to search 2 columns. IF any number in any of the columns is 1, I want to total it up.</p>
  
  <p>here is my formula:</p>
  
  <pre><code>COUNTIF(('Background data'!$A:$A,'Background data'!B:B), 1).
  </code></pre>
  
  <p>However, when I apply it, I get an error saying 'Value used in the formula is the wrong data type'. </p>
  
  <p>To fix this issue, I went to the Background Data tab and</p>
  
  <ol>
  <li>Set all Columns to Numerical data type</li>
  <li>Set all columns to Numerical data type in the tab that I am currently working on</li>
  <li>Individually tested the countif formula with either column A and then column B and then I don't receive the error. This concludes that my columns are of the correct data type.</li>
  </ol>
  
  <p>I am guessing I'm getting the error because there is an error in my formula and not the actual data?</p>