title: Ignore hidden columns in SUM(x:y), like AGGREGATE can ignore hidden rows
body: <p>I know there is a similar answer here: 
  <a href="https://stackoverflow.com/questions/28589839/ignoring-a-hidden-column-in-an-excel-sum-formula">Ignoring a hidden column in an excel sum formula</a></p>
  
  <p>...and it's a good one, but it isn't ideal for me. I really just need a simple function I can apply dynamically.</p>
  
  <p>Is there a way to do this in a similar way to the <code>AGGREGATE</code> function?
  <code>AGGREGATE</code> almost works for me, except it annoyingly ignores hidden rows but not columns!</p>
  
  <p>For example:</p>
  
  <p>I have a worksheet with values in <code>A5:A10</code>.</p>
  
  <p>If I set the formula of <code>A11</code> to <code>=SUM(A5:A10)</code> I get the expected amount, whether columns are hidden or not.</p>
  
  <p>If I use <code>=AGGREGATE(9,5,A5:A10)</code> the results are the same, although if I did this across rows rather than columns the hidden rows would be ignored in the calculation.</p>
  
  <p>Is there a simple way to do this or is the only way to check the width of each column, as in the answer provided?</p>