title: Is there a way to calculate standard deviation on a range of cells only for cells where the value is greater than 0 in Excel?
body: <p>I have a range of cells, say A1 to A100. I want to calculate the standard deviation for that range of cells but only take into account cells where the value is greater than 0. Is there a way to do this in excel? I tried <code>=stdev(if(A1:A100&gt;0,A1:A100,0))</code> but it does not seem to be giving me the right results.</p>