title: How to do an array formula with a structured reference?
body: <p>I need to calculate the <code>MEDIAN</code> of the rows matching some conditions.</p>
  
  <p>Conditions are in the rows A, B, C and D and my infos are in a table called <code>classic_v2_log</code>. When I'm using the Sheet Name it works:</p>
  
  <pre><code>=MEDIAN(IF((ClassicRAW!B:B=A35)*(ClassicRAW!C:C=B35)*(ClassicRAW!D:D=C35)*(ClassicRAW!E:E=D35),ClassicRAW!F:F))
  </code></pre>
  
  <p>But if I try to use the Table reference it gives me a <code>#N/A</code> and if I try to use the <code>Show Calculation Steps</code> it goes beyond the Table.</p>
  
  <p>I'm trying something like this and it's not working:</p>
  
  <pre><code>=MEDIAN(IF((classic_v2_Log[ [ Epochs] ]=A35),ClassicRAW!F:F))
  </code></pre>
  
  <p>I am confirming the formula with Ctrl+Shift+ENTER to make it as an array-formula.</p>