title: formula Subtotal 109 when hiding columns does not work in excel
body: <p>I have formulas in column B which subtotal every other column starting with column E.  So column E, G, I, K, M, O, Q, S, and eventually more.  The formula in row 4 is</p>
  
  <pre><code>=SUBTOTAL(109,E4,G4,I4,K4,M4,O4,Q4,S4)
  </code></pre>
  
  <p>When I hide one of these columns the total in column B does not adjust to reduce the value.</p>
  
  <p>Any ideas what might be causing this.  It seems that this should be straightforward. I've used subtotal before and it works in my other workbooks.  This is a simple work book or so it seems. 55 rows on the sheet with 52 of them having this formula.  None of them work.  This will be simple I'm sure and I will be embarrased but I have tried a number of things unsuccessfully.</p>