title: Why does my Average and AverageIF formula differ?
body: <p>I have a date range 7/5/2019 to 7/19/2019. The values for each date depicted:</p>
  
  <pre><code>7/5  19
  7/8  35
  7/9  29
  7/10  40
  7/11  33
  7/12  19
  7/15  35
  7/16  37
  7/17  30
  7/18  60
  7/19  41
  </code></pre>
  
  <p>(As noticed, not all dates are shown as they do not have any value assigned.)</p>
  
  <p>Essentially, I am wondering why do the Average and AverageIF formulas differ with the returned value? </p>
  
  <p>AverageIF formula:  <code>=AVERAGEIF($A$1:$K$1,"&gt;="&amp;TODAY()-14,$A2:$K2)</code> returns 37</p>
  
  <p>Average formula:  <code>=AVERAGE(A2:K2)</code> returns 34</p>