Average cells that contain numbers ignoring zeros

{=AVERAGE(IF(CellRange<>0,CellRange))}