title: Missing values in MS Excel LINEST, TREND, LOGEST and GROWTH functions
body: <p>I'm using the GROWTH (or LINEST or TREND or LOGEST, all make the same trouble) function in Excel 2003. But there is a problem that if some data is missing, the function refuses to give result:</p>
  <p><img src="https://i.stack.imgur.com/adkZ9.png" alt="enter image description here" /></p>
  <p>You can <a href="http://artax.karlin.mff.cuni.cz/%7Ettel5535/pub/SO_missing_values.xls" rel="nofollow noreferrer">download the file here</a>.</p>
  <h2>Is there any workaround? Looking for easy and elegant solution.</h2>
  <ol>
  <li><p>I don't want the obvious workaround of getting rid of the missing value - that would mean to delete the column and that would also damage the graph, and it would make problems in my other tables where I have more rows and missing data in different columns. Other obvious workaround is to use one data for regression and the other for graph, but again, this is annoying and only makes mess in the sheet!!</p>
  </li>
  <li><p>Is there any way to tell excell - this value is NA?</p>
  </li>
  <li><p>Another idea would be to skip the missing value(s) in the expression. Is it possible to address a set of cells that is not continuous? Like instead of <code>=GROWTH($B2:$AH2; $B1:$AH1; B1)</code> as in my example, use something like:</p>
  <p><code>=GROWTH({$B2:$I2,$K2:$AH2}; {$B1:$I1,$K1:$AH1}; B1)</code></p>
  </li>
  <li><p>I'd of course like to avoid writing my own expressions. I need to explain this to my colleagues how to do all this and it would much more complicated. I want an easy and elegant solution.</p>
  </li>
  </ol>