How to return 0 instead of #DIV/0!

[scmuddy]

Hello
I have tried several formulas trying to get my average formula to work an
kee
drawing a blank

My formula is as follows: =AVERAGEIF(Z6:AE6,"<>0",Z6:AE6

If the cell has a number in it works, but on some the cells the answer need
t
show 0 otherwise I have to manually change the cell to 0 which is a pain

Hope you can help

Regard
Steve

 

[David Biddulph]

=IF(COUNT(Z6:AE6)=0,0,AVERAGEIF(Z6:AE6,"<>0",Z6:AE6)) ?