I am struggling with a formula that in some instances needs to divide by zero.

I am using the formula =Sum(A1:A10)/Count(A1:A10).

In some cases there are numbers in the referenced cells and in some cases the cells are zero.

I get the result I want if I create the formula =Sum(A1:A10) in cell A11; =Count(A1:A10) in cell A12; and =A11/A12 in cell A13. However I would like to do it in one step if possible.

Help is always appreciated.