title: Can I use COUNTIF on two columns to compare values?
body: <p>I have two columns in Excel, like this:</p>
  
  <pre><code> A   B
  0.5  0.4
  0.6  0.59
  0.1  0.2
  0.3  0.29
  </code></pre>
  
  <p>I want to count how many of the values in B are less than their corresponding values in A. In this case, the answer is 3.</p>
  
  <p>I can do this by adding an extra column, <code>B-A</code> and then doing <code>COUNTIF(RANGE, "&lt;0")</code>, but I am wondering if there's a way to do it without adding an extra column.</p>
  
  <p>I realize this is on the fringes of what one might consider programming, but hopefully it's just on the right side of the line, rather than the wrong side.</p>