Pipeline coverage formula in Excel or Google Sheets
Put the inputs in column B from row 2, then paste the formulas below. They work the same in Excel and Google Sheets.
| Cell | What | Value or formula | Example |
|---|---|---|---|
| B2 | Open pipeline for the period ($) | 900000 | 900000 |
| B3 | Quota still to close ($) | 300000 | 300000 |
| B4 | Target coverage (x) | 3 | 3 |
| B6 | Pipeline coverage (x) | =ROUND(B2/B3,2) | 3 |
| B7 | Pipeline needed at target ($) | =B3*B4 | 900000 |
| B8 | Pipeline still to build ($) | =MAX(0,B7-B2) | 0 |
Get the ready-made spreadsheet
The same calculator as an .xlsx file, with the formulas set up. Free: enter your email and the download starts here right away. Your email also joins Clarivoxx Insights (a weekly article and a monthly newsletter; unsubscribe in one click).
Frequently asked questions
- How do you calculate pipeline coverage?
- Divide the value of open opportunities expected to close in the period by the quota you still need to close. $900,000 of pipeline for $300,000 of remaining quota is 3× coverage.
- What is a good pipeline coverage ratio?
- Use 1 ÷ your win rate: with a 25% win rate you need 4×, with 33% about 3×. The 3× rule only works if your win rate is close to one in three.
- Why does high coverage still miss target?
- Because old or unqualified deals inflate it. Count only opportunities with a close date in the period and a real next step.
About the author
Abdessamad Ghanem
Customer Experience & Customer Success Consultant · Founder of Clarivoxx
Abdessamad Ghanem works across Customer Support, Sales, Customer Success, Account Management and Partner Management. He writes Clarivoxx Insights for B2B SaaS professionals who own retention, adoption and customer outcomes.