Quality Form formula problem

Hi!

This is my first time to create a quality form and I only have basic knowledge of formulas.
Challenge #1: On my Compliance error rate when tagged as N/A, N/A is still being a divisor to get the final score, I suppose i am needing condition for the NA.
Challenge #2: Is there a way to remove the 0.00% on the compliance error and 100.00% on the over all quality if questions are not answered yet so I can get an an average for both accurately?


Please help!

Try

=IF(COUNT(O7:O31)=0,"",SUM(O7:O12,O15:O17,O22:O25,O28,O31)/15)

and

=IF(COUNT(O7:O31)=0,"",$O$33-O32)

for #N/A errors

=IFERROR( your formula,"")