Pipeline coverage compares open pipeline value to the quota or gap you must close — how many times over your pipeline covers the goal. A common rule of thumb is 3× or more.
The example
$600k pipeline, $200k to close.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Open pipeline | 600000 |
| 3 | Gap to quota | 200000 → 3.0x |
The formula
The formula:
How it works
How it works:
- Open pipeline is the total value of deals not yet closed.
- Divide by the quota remaining (the gap still to hit) for the coverage ratio.
- A ratio of 3× or more is a common health benchmark — it accounts for typical win rates.
- Below your benchmark signals you need to build more pipeline to hit the number.
The right coverage equals 1/win-rate, roughly. If you win ~33% of pipeline, you need ~3× coverage to close the gap; a 50% win rate only needs ~2×. So coverage and win rate are linked — a team with a higher win rate can hit quota on thinner pipeline. Benchmark coverage against your own win rate, not a generic 3×.
Try it: interactive demo
Open pipeline and quota remaining.
Variations
Pipeline needed
For 3x coverage:
Coverage vs win rate
Required coverage:
Open pipeline (SUMIF)
From the CRM:
Pitfalls & errors
Gap, not full quota. Divide by what’s left to close, not the whole quota.
Benchmark to your win rate. 3× is generic; ~1/win_rate is yours.
Open deals only. Pipeline is unclosed value — exclude won/lost.
Practice workbook
Frequently asked questions
How do I calculate pipeline coverage in Excel?
What's a healthy coverage ratio?
Should I divide by full quota or the gap?
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