No-show rate is missed appointments over scheduled appointments — a key clinic operations metric. COUNTIF tallies the statuses straight from a schedule.
The example
12 missed of 200 booked.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | No-shows | 12 |
| 3 | Scheduled | 200 → 6% |
The formula
The formula:
How it works
How it works:
COUNTIF(status, "No-show")counts the missed appointments.- Divide by
COUNTA(status)— total scheduled — for the rate. - Track cancellations separately with another COUNTIF for a fuller picture.
- Slice by provider, day, or month with COUNTIFS to find patterns to address.
Segment to act on it. A clinic-wide no-show rate hides where the problem is. COUNTIFS by provider, weekday, or appointment type reveals that (say) Monday-morning new-patient slots no-show far above average — the kind of insight that justifies reminder calls or overbooking those slots.
Try it: interactive demo
No-shows and total scheduled.
Variations
Cancellation rate
Another status:
Completion rate
Kept appointments:
By provider
Segment it:
Pitfalls & errors
Consistent statuses. "No-show" must be typed the same way everywhere.
Right denominator. Divide by scheduled, not completed.
Separate cancellations. A cancelled slot isn’t the same as a no-show.
Practice workbook
Frequently asked questions
How do I calculate no-show rate in Excel?
How do I find no-shows by provider?
Should cancellations count as no-shows?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class