How to get rid of #DIV/0! in an array


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!

By: Madelief

Leave a Reply

Your email address will not be published. Required fields are marked *