I am trying to use the following formula and I am getting the #VALUE! error. Any thoughts:

=IF(J29=0,"",1&":"&(ROUNDDOWN(AVERAGE(J12:J26=0,"",J12:J26),0)))

Thanks