The formula im using is =IF(OR(E20="",E21="",E22),"",SUMIF(E20:E22,"Yes",$C20:$C22)/(1-SUMIF(E20:E22,"N/A",$C20:$C22)/SUM($C20:$C22))*IF(COUNTIFS($D20:$D22,"auto zero",E20:E22,"No"),0,1))

When applying your part i end up with:

=IF(COUNTBLANK(X1:X10)>0,"Error",IF(OR(E20="",E21="",E22),"",SUMIF(E20:E22,"Yes",$C20:$C22)/(1-SUMIF(E20:E22,"N/A",$C20:$C22)/SUM($C20:$C22))*IF(COUNTIFS($D20:$D22,"auto zero",E20:E22,"No"),0,1))

The part highlighted in red is designed to keep the cell blank, however when i apply your part of the formula, the cell value is error until all relevant cells are populated. Then the percentage is displayed. See E23. File attached