title: Formula resulting in 0 in cell, but in function window it gives a correct answer
body: <p>I'm trying to calculate the standard deviantion from a population and was using the STDEV.P function to do this. But when I inserted it into a cell, the resulting answer was 0. When I looked into the Function window, it gave an (more resonable) answer (around 7600).</p>
  
  <pre><code>=STDEVPA(IF(Tests!H:H = "Motion",Tests!D:D))
  </code></pre>
  
  <p>How can I make sure the cell also gives the right answer</p>
  
  <p>Sample data:</p>
  
  <pre><code>24  1.46791E+12 1.46791E+12 31544   FALSE   TRUE    FALSE   Still   2   1   3   2   6
  1   1.46729E+12 1.46729E+12 26515   FALSE   FALSE   TRUE    Motion  1   1   1   2   4
  </code></pre>