Win Rate Formula Explained With the Right Deals to Count
The win rate formula is `closed-won deals ÷ (closed-won deals + closed-lost deals) × 100`. In plain English, you count the deals that ended in a clear win or a clear loss, then convert that share into a percentage. By default, this is a closed-deal metric: open opportunities usually stay out of the calculation until they close.
The win rate formula in one line
The standard win rate formula is:
win rate = closed-won deals ÷ (closed-won deals + closed-lost deals) × 100
That gives you a percentage. If you want the decimal instead, leave off the × 100.
The important part is the denominator: it should include only deals with a known outcome. That’s why win rate usually means opportunity win rate or sales win rate, not lead conversion rate.
Which deals count and which ones don’t
In practice, the tricky part is deciding what counts as a won or lost deal before you run the report.
Use this rule of thumb:
closed-wonbelongs in the numerator and the denominator.closed-lostbelongs in the denominator only.- Open deals stay out until they close.
- No-decision deals usually stay out unless your team records them as lost.
- Duplicate opportunities should be merged or removed before you calculate the metric, or the CRM can double-count them.
A simple decision table helps:
| Record type | Count it? |
|---|---|
| Closed-won opportunity | Yes, numerator and denominator |
| Closed-lost opportunity | Yes, denominator only |
| Open opportunity | No |
| No-decision opportunity | Usually no, unless your team classifies it as lost |
| Duplicate opportunity | No, not as a separate deal |
For this formula, a “won” deal is one that your team has marked closed-won in the system. A “lost” deal is one that your team has marked closed-lost. If your CRM has another final status, map it to one of those two buckets before you calculate the rate, or leave it out and be consistent.
Some teams calculate win rate on proposals instead of opportunities, especially when one opportunity can generate several quotes or bids. That can work, but only if a proposal is the actual unit your team sells and tracks. Calls are different. A call can help create a deal, but it is not the usual denominator for win rate. If you use calls as the denominator, you are measuring a different activity metric, not standard sales win rate.
A simple example you can copy
Say you have 10 opportunities that have already closed.
- 4 are
closed-won - 6 are
closed-lost
The formula is:
4 ÷ (4 + 6) × 100 = 40%
So the win rate is 40%.
Now say you have 4 wins, 5 losses, and 3 open deals. You still use only the closed deals for this version of the metric:
4 ÷ (4 + 5) × 100 = 44.4%
The open deals do not enter the calculation until they close. That keeps the number tied to actual outcomes instead of pipeline that is still in flight.
Win rate vs close rate vs conversion rate
These terms overlap, and different teams use them differently.
Usually:
win ratemeans wins divided by closed wins plus closed losses.close ratecan mean the same thing, but not in every team.conversion rateis broader and may mean leads to opportunities, opportunities to deals, or another stage-to-stage step.
The denominator is where people get tripped up. If someone says “conversion rate,” ask what stage they are converting from and to. If someone says “close rate,” ask whether they mean only closed deals or all opportunities created in the period.
A team can have a strong opportunity win rate and a weak lead conversion rate at the same time. They answer different questions, so they should not be treated as the same number.
How to calculate it in a spreadsheet or CRM
The cleanest setup is to pick one reporting rule and stick to it. In most sales reports, that means choosing one of these:
- Deals closed in the period, using
closed-wonandclosed-lostonly - Opportunities created in the period, then measured only after they close
- Proposals sent in the period, if proposals are your real unit of work
In a spreadsheet, put one deal on each row, give it a final status, and count only the rows marked won or lost. Then calculate:
wins / (wins + losses)
If you want the percentage, format the cell as a percent or multiply by 100.
In a CRM, check the filters carefully. A report can quietly drift if duplicate opportunities, stale stages, or lost deals with no close date are still in the data. If a deal was never formally closed, decide in advance whether your team will clean it up, mark it lost, or leave it out of the report. Don’t mix those choices from one report to the next.
If you’re building this for a dashboard, I’d also sanity-check the stage definitions. A low win rate can come from weak qualification, but it can also come from loose stage hygiene or a pile of stale records. A high win rate isn’t automatically good news either. It can mean strong qualification, or it can mean the team is only logging very safe deals. Read the number next to average deal size, sales cycle length, stage quality, and how consistently the CRM is updated.
How to read a high or low win rate without overreacting
A win rate is useful, but only if you read it in context.
If it’s low, I’d first ask whether the team is chasing poor-fit deals, whether the pipeline has too many stale opportunities, or whether the CRM is counting deals differently from rep to rep. A low number does not automatically mean the team is underperforming.
If it’s high, I’d ask the opposite: are we really winning a lot, or are we only taking the easiest deals? A very high win rate can look great while still hiding a small or overly cautious pipeline.
The safest way to use the metric is as a trend, not a verdict. Compare like with like, keep the denominator consistent, and check whether the underlying deal mix changed before you make a big call.