title: Average using a difference from MAX in Excel
body: <p>I am trying to average a column of numbers, throwing out values a specific difference from MAX. The users will not be Excel experts, so I am trying to stay away from Array formulas so they can edit the difference number based on different conditions.</p>
  
  <pre><code>=AVERAGEIF(DM7:DM34,"=&gt;Max(DM7:DM34)-3",DM7:DM34)
  </code></pre>
  
  <p>This returns a #Div/0, while the MAX portion alone returns the value I need.</p>