title: MAXIFS multiple criteria ignoring NA() data
body: <p>I am trying to get the maximum value of a column within a certain range and ignore the NA() values that are in the column. All of the data in the column that is not NA() is greater than zero. I have tried ignoring the <code>NA(), &gt;=0</code> and the AGGREGATE function does not have the <code>MAXIFS</code> only the MAX function.</p>
  
  <pre><code>=MAXIFS(SR_Layer2,Chainage,"&gt;="&amp;D12,Chainage,"&lt;="&amp;E12,SR_Layer2,"&lt;&gt;NA()")
  =MAXIFS(SR_Layer2,Chainage,"&gt;="&amp;D12,Chainage,"&lt;="&amp;E12,SR_Layer2,"&gt;=0")
  </code></pre>
  
  <p>It displays the <code>#VALUE!</code></p>