title: Calculate standard deviation only on values between x and y
body: <p>i have a range of data in column a called mycol. Some values are clearly errors (ie, less than 0 or over 100000. If I don't omit those values the stdev is highly skewed. Therefore I want to calculate the stdev only on the values >0 and &lt; 100000. Can you please explain the best way to do this? </p>
  
  <p>I thought about creating a named range consisting of only those within the limits, but I'm not sure if named ranges are dynamic in that way.</p>