=SUM($B$2:B2)/SUM($B$2:$B$4)
| Total Units (A) | Passed First Time (B) | RFT (C) | |----------------|----------------------|---------| | 500 | 470 | =470/500 → 94% | rft formula in excel
= AND(B2="Pass", C2="Pass", D2="Pass")
| A | B | C | |---|---|---| | Total Units | Units with no rework/defects | RFT (%) | rft formula in excel
Management doesn’t want lifetime RFT; they want last month’s RFT. Use COUNTIFS with date criteria. rft formula in excel
RFT (%) = (Number of units that pass quality inspection on first attempt / Total number of units produced) × 100