I hope someone can help me with this question. I am trying to calculate the standard deviation of a row of cells, however i would like to not include any zero values. I have used the formula: =STDEV(IF(B3:AX3>0,B3:AX3)) and entered it as an array. However, this returns for cells that are zero #DIV/0!. I cannot seem to edit the formula so that i do not get the error. Does anybody know what i can do to resolve this issue?
Thanks so much in advance!