title: How does Excel's FREQUENCY function work?
body: <p>With the following function:</p>
  
  <pre><code>=FREQUENCY(C2:C724,D2:D37)
  </code></pre>
  
  <p>The second parameter is the <code>BIN</code></p>
  
  <p>What I don't understand is why Excel would increment the <code>BIN</code> for the rest of your values. The BIN does not change! It stays the same bin. Yet when I paste the formula for all my values it does this:</p>
  
  <pre><code>=FREQUENCY(C2:C724,D2:D37)
  =FREQUENCY(C2:C724,D3:D38)
  =FREQUENCY(C2:C724,D4:D39)
  </code></pre>
  
  <p>The last column is what was generated (and this is correct but it does not make sense!!)</p>
  
  <pre><code>Etoh        bin
  15.9        20        0
  14.6        19        0
  14.1        18        0
  13.9        17        0
  13.3        16        0
  13.3        15        0
  13.2        14        1
  12.6        13        2
  12.1        12        3
  11.8        11        6
  11.5        10        4
  11.2         9        4
  11           8        8
  10.5         7       10
  10.3         6       26
  10.3         5       27
  10.2         4       40
  10.1         3       89
  9.8          2      151
  9.7          1      205
  9.5          0      102
  9.1         -1       17
  8.9         -2        7
  8.3         -3        3
  8.1         -4        2
  8.1         -5        0
  7.9         -6        3
  7.6         -7        2
  7.5         -8        2
  7.5         -9        1
  7.5        -10        1
  7.4        -11        0
  7.2        -12        0
  7.1        -13        1
  7.0        -14        0
  7.0        -15        0
  6.8
  6.7
  6.6
  6.5
  6.4
  6.2
  6.2
  6.1
  6.0
  5.9
  5.8
  5.8
  5.7
  5.7
  5.7
  5.5
  5.5
  5.5
  5.4
  5.3
  5.3
  5.3
  5.3
  5.3
  5.3
  5.3
  5.2
  5.2
  5.2
  5.1
  5.1
  5.1
  5.1
  5.1
  5.0
  5.0
  5.0
  5.0
  5.0
  4.9
  4.9
  4.8
  4.8
  4.8
  4.7
  4.7
  4.6
  4.6
  4.6
  4.5
  4.5
  4.5
  4.5
  4.4
  4.3
  4.1
  4.1
  4.1
  4.1
  4.1
  4.1
  4.0
  4.0
  4.0
  4.0
  4.0
  3.9
  3.9
  3.9
  3.9
  3.9
  3.8
  3.8
  3.7
  3.6
  3.6
  3.6
  3.6
  3.6
  3.5
  3.5
  3.4
  3.4
  3.4
  3.4
  3.3
  3.3
  3.3
  3.3
  3.2
  3.2
  3.2
  3.2
  3.2
  3.2
  3.1
  3.1
  3.1
  3.1
  3.1
  3.1
  3.0
  3.0
  3.0
  3.0
  3.0
  3.0
  3.0
  3.0
  3.0
  3.0
  3.0
  2.9
  2.9
  2.9
  2.8
  2.8
  2.8
  2.8
  2.8
  2.8
  2.8
  2.8
  2.7
  2.7
  2.7
  2.7
  2.7
  2.7
  2.7
  2.7
  2.6
  2.6
  2.6
  2.6
  2.6
  2.6
  2.6
  2.6
  2.6
  2.5
  2.5
  2.5
  2.5
  2.5
  2.4
  2.4
  2.4
  2.4
  2.4
  2.4
  2.4
  2.4
  2.3
  2.3
  2.3
  2.3
  2.3
  2.3
  2.3
  2.3
  2.3
  2.3
  2.3
  2.3
  2.2
  2.2
  2.2
  2.2
  2.2
  2.2
  2.2
  2.2
  2.2
  2.2
  2.2
  2.2
  2.1
  2.1
  2.1
  2.1
  2.1
  2.1
  2.1
  2.1
  2.1
  2.1
  2.1
  2.1
  2.1
  2.0
  2.0
  2.0
  2.0
  2.0
  2.0
  2.0
  2.0
  2.0
  2.0
  2.0
  2.0
  2.0
  2.0
  1.9
  1.9
  1.9
  1.9
  1.9
  1.9
  1.9
  1.9
  1.9
  1.9
  1.9
  1.9
  1.9
  1.9
  1.9
  1.8
  1.8
  1.8
  1.8
  1.8
  1.8
  1.8
  1.8
  1.8
  1.8
  1.8
  1.8
  1.8
  1.8
  1.8
  1.7
  1.7
  1.7
  1.7
  1.7
  1.7
  1.7
  1.6
  1.6
  1.6
  1.6
  1.6
  1.6
  1.6
  1.6
  1.6
  1.6
  1.6
  1.6
  1.5
  1.5
  1.5
  1.5
  1.5
  1.5
  1.5
  1.5
  1.5
  1.5
  1.5
  1.5
  1.5
  1.5
  1.5
  1.5
  1.5
  1.5
  1.4
  1.4
  1.4
  1.4
  1.4
  1.4
  1.4
  1.4
  1.4
  1.4
  1.4
  1.4
  1.4
  1.3
  1.3
  1.3
  1.3
  1.3
  1.3
  1.3
  1.3
  1.3
  1.3
  1.3
  1.3
  1.3
  1.3
  1.3
  1.3
  1.3
  1.3
  1.3
  1.3
  1.3
  1.3
  1.2
  1.2
  1.2
  1.2
  1.2
  1.2
  1.2
  1.2
  1.2
  1.2
  1.2
  1.2
  1.2
  1.2
  1.2
  1.2
  1.2
  1.1
  1.1
  1.1
  1.1
  1.1
  1.1
  1.1
  1.1
  1.1
  1.1
  1.1
  1.1
  1.1
  1.1
  1.1
  1.1
  1.1
  1.1
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  1.0
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.9
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.8
  0.7
  0.7
  0.7
  0.7
  0.7
  0.7
  0.7
  0.7
  0.7
  0.7
  0.7
  0.7
  0.7
  0.7
  0.7
  0.7
  0.6
  0.6
  0.6
  0.6
  0.6
  0.6
  0.6
  0.6
  0.6
  0.6
  0.6
  0.6
  0.6
  0.6
  0.6
  0.5
  0.5
  0.5
  0.5
  0.5
  0.5
  0.5
  0.5
  0.5
  0.5
  0.5
  0.5
  0.5
  0.5
  0.5
  0.5
  0.5
  0.5
  0.5
  0.4
  0.4
  0.4
  0.4
  0.4
  0.4
  0.4
  0.4
  0.4
  0.4
  0.4
  0.4
  0.4
  0.4
  0.4
  0.4
  0.4
  0.4
  0.4
  0.4
  0.3
  0.3
  0.3
  0.3
  0.3
  0.3
  0.3
  0.3
  0.3
  0.3
  0.3
  0.3
  0.3
  0.3
  0.3
  0.3
  0.3
  0.3
  0.3
  0.3
  0.3
  0.3
  0.3
  0.2
  0.2
  0.2
  0.2
  0.2
  0.2
  0.2
  0.2
  0.2
  0.2
  0.2
  0.2
  0.2
  0.2
  0.2
  0.2
  0.2
  0.2
  0.1
  0.1
  0.1
  0.1
  0.1
  0.1
  0.1
  0.1
  0.1
  0.1
  0.1
  0.1
  0.1
  0.1
  0.1
  0.1
  0.1
  0.1
  0.1
  0.1
  0.0
  0.0
  0.0
  0.0
  0.0
  0.0
  0.0
  0.0
  0.0
  0.0
  0.0
  0.0
  0.0
  0.0
  0.0
  0.0
  0.0
  0.0
  0.0
  0.0
  0.0
  0.0
  -0.1
  -0.1
  -0.1
  -0.1
  -0.1
  -0.1
  -0.1
  -0.1
  -0.1
  -0.1
  -0.1
  -0.1
  -0.1
  -0.1
  -0.2
  -0.2
  -0.2
  -0.2
  -0.2
  -0.2
  -0.2
  -0.2
  -0.2
  -0.2
  -0.2
  -0.3
  -0.3
  -0.3
  -0.3
  -0.3
  -0.3
  -0.3
  -0.3
  -0.3
  -0.3
  -0.4
  -0.4
  -0.4
  -0.4
  -0.4
  -0.4
  -0.4
  -0.4
  -0.4
  -0.4
  -0.4
  -0.5
  -0.5
  -0.5
  -0.5
  -0.5
  -0.5
  -0.6
  -0.6
  -0.6
  -0.6
  -0.6
  -0.6
  -0.7
  -0.7
  -0.7
  -0.7
  -0.7
  -0.7
  -0.7
  -0.7
  -0.8
  -0.8
  -0.8
  -0.8
  -0.8
  -0.8
  -0.8
  -0.8
  -0.9
  -0.9
  -0.9
  -0.9
  -0.9
  -0.9
  -1.0
  -1.0
  -1.0
  -1.0
  -1.0
  -1.0
  -1.1
  -1.1
  -1.2
  -1.2
  -1.2
  -1.3
  -1.3
  -1.7
  -1.8
  -1.9
  -1.9
  -2.1
  -2.2
  -2.4
  -2.4
  -2.5
  -2.5
  -2.6
  -3.0
  -3.2
  -3.7
  -4.6
  -4.6
  -6.1
  -6.3
  -6.3
  -7.0
  -7.8
  -8.1
  -8.5
  -9.0
  -10.2
  -13.2
  </code></pre>
  
  <p>If I do as both of you suggested with the $, I am getting the WRONG results:</p>
  
  <pre><code>0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  </code></pre>