=IF(J29=0,"",1&":"&(ROUNDDOWN(AVERAGE(J12:J26=0,0,J12:J26),0)))
Your formula, works if you remove the ""
=IF(J29=0,"",1&":"&(ROUNDDOWN(AVERAGE(J12:J26=0,0,J12:J26),0)))
Your formula, works if you remove the ""
If someone helped give them rep using the star button.
If you have received a satisfactory solution please mark the thread solved. If not Fotis will come for you at night :P
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks