title: Calculate subtotal over column with aggregate functions
body: <pre><code>       A              B         C            D         E         F
  1                   2300       #NA           0
  2
  3   Product A       500        #NA         500
  4   Product B       400        100         500
  5   Product C       300        #NA         300
  6   Product D       200        800        1.000
  7   Product E       900        900        1.800
  8
  </code></pre>
  
  <p>In the table above I have list of products in <code>Column A</code>. <br>
  In <code>Column B</code> and <code>Column C</code> I have corresponding values to those products. <br>
  In <code>Column D</code> I want to <code>Sum</code> the values from <code>Column B</code> and <code>Column C</code>. <br>
  As you can see <code>Column C</code> contains <code>=NA</code> values. In order to ignore them I went with <code>=AGGREGATE(9,6,B3:C3)</code> in <code>Column D</code>.</p>
  
  <p>Alls this works exactly the way I want it.</p>
  
  <hr>
  
  <p>However, now in <code>Cell D1</code> I want to <code>sum up</code> the values in <code>Column D</code> but instead of using <code>SUM</code> I want to go with <code>=SUBTOTAL(9,D3:D7)</code> because I am going to apply a filter to the list later on.</p>
  
  <p>The <code>subtotal</code> formula gives me <code>0</code> as a result. When I type the values in <code>Column D</code> manually in <code>Column E</code> and put the <code>subtotal</code> formula over <code>Column E</code> it works. Therefore, I assume this issue is somehow caused by the <code>AGGREGATE</code> function in <code>Column D</code>.</p>
  
  <p>How do I have to modify the formula in <code>Cell D1</code> or the formulas in <code>Column D</code> to get the correct subtotal?</p>