| A | |---| | Pass | | Pass | | Fail | | Pass |
= COUNTIF(A2:A5, "Pass") / COUNTA(A2:A5) Format as percentage. If each unit must pass several checks (e.g., Appearance, Function, Packaging):
Step1 RFT = 95%, Step2 RFT = 90%, Step3 RFT = 98%
| A | |---| | Pass | | Pass | | Fail | | Pass |
= COUNTIF(A2:A5, "Pass") / COUNTA(A2:A5) Format as percentage. If each unit must pass several checks (e.g., Appearance, Function, Packaging):
Step1 RFT = 95%, Step2 RFT = 90%, Step3 RFT = 98%







