A few moments ago a solution was correctly present on the correct way to exclude a zero in an average.
With this formula: =AVERAGEIF(A1:A10,"<0>") gives me #DIV! error.
Now let's take this to the next level. Average a range excluding zero without #DIV! or other error code. I tried this:
=IFERROR(AVERGEIF(A1:A10,"<0">)) and it failed.