Like:

=IF(E29=0,"",1&":"&INT(AVERAGE(E29,J29,O29,T29,Y29,AD29,AI29)))