title: #value error mac excel 2016 array formula
body: <p>I'm getting a #value error in Excel 2016 on a mac. </p>
  
  <p>Formula: </p>
  
  <pre><code>=MEDIAN(IF('Instructional RAW'!$C:$C,'Lead Teacher (42)'!$E$12,IF('Instructional RAW'!$G:$G,'Lead Teacher (42)'!E$28,'Instructional RAW'!$R:$R)))
  </code></pre>
  
  <p>Adding dummy data: </p>
  
  <pre><code>Job Code    Average Salary  Type
  42  $60,000 Single site
  42  $26,000 Single site
  42  $26,500 Multi site
  40  $62,000 Single site
  49  $40,000 Multi site
  42  $45,000 Multi site
  21  $33,000 Single site
  43  $30,000 Multi site
  42  $51,500 Single site
  </code></pre>
  
  <p>Desired outcome: calculate the median salary based on a set of conditions - job code = 42, school type = single site. </p>
  
  <p>When clicking ctrl+shift+enter, I get the value error. Thoughts? </p>