How do I hide a divide by zero error from an average formula?

[Dave Peterson]

=if(count(a1:a10)=0,"No numbers",average(a1:a10))

is one way.

Julia wrote:

 

[daddylonglegs]

To return a zero rather than #DIV/0!

=SUM(A1:A10)/MAX(1,COUNT(A1:A10))