title: How to count the number of values that are between intervals in excel
body: <h1>Problem</h1>
  <p>Let <em>v = {v1, v2, v3,.., vn}</em> be a set of unsorted real numbers.</p>
  <p>I want to count to number of values vi that fall in the intervals [0,10], [20,28] etc.</p>
  <hr />
  <h1>Example</h1>
  <p>Let <code>v = {2.6, 3.1, 7, 10, 22, 21, 27}</code></p>
  <ul>
  <li>The number of values that fall in the interval <em>[0,10]</em> are: <em>2.6,3.1,7,10</em></li>
  <li>The number of values that fall in the interval <em>[20, 28]</em> are : <em>22, 21 ,27</em></li>
  </ul>
  <hr />
  <p>I used the following formula: <code>=SUMPRODUCT((range&gt;0)*(range&lt;10))</code></p>