title: Ignore zeros (or blanks) in Excel LINEST function with multiple independent variables
body: <p>I would like to run a multiple (!) factor analysis through linest, again excluding all rows that contain zeros (or if that’s easier blank cells). Is there a way I can do this using the linest functions?</p>
  
  <p>I tried using the following formular, which I have found somewhere else, but would not get anything but #VALUE!.</p>
  
  <pre><code>=LINEST(IF(ISNUMBER(C15:C26);C15:C26;);IF(ISNUMBER(C15:C26);CHOOSE({1;2;3};1;D15:D26;E15:E26););1;1)
  </code></pre>
  
  <p>FYI – Y values are is column C, and my X values in column D &amp; E.</p>
  
  <p>Thanks in advance!
  Julian</p>
  
  <p><a href="https://i.stack.imgur.com/J77eT.png" rel="nofollow noreferrer">enter image description here</a></p>