Why you need this
Your Win Rate is the heartbeat of sales efficiency. This formula divides the number of 'Won' deals by the total number of deals.
Improve this metric to increase revenue without adding more leads.
One-Click Copy
=COUNTIF(StatusRange, "Won") / COUNTA(StatusRange)
Copy
Quick context
- • Works in both Excel and Google Sheets.
- • Use when you need consistent, auditable results.
- • Copy the snippet above and adjust only the ranges.
When to use
Learn how to use the Excel Win Rate Formula formula.
Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.
Commission Risk
Broken formulas cost commissions. Automate your compensation plans and quota tracking.
See sales Alternatives