title: How do I count cells that are between two numbers in Excel?
body: <p>I need a formula to count the number of cells in a range that are between 10 and 10.000:</p>
  
  <p>I have: </p>
  
  <pre><code>=COUNTIF(B2:B292,&gt;10 AND &lt;10.000) 
  </code></pre>
  
  <p>But how do I put the comparison operators in without getting a formula error?</p>