How to Calculate a Weighted Pipeline (Formula and Example)
A weighted pipeline is a sales forecast that multiplies the value of each open deal by its chance of closing, then adds the results. A 6,000 deal with a 50% chance counts as 3,000. It gives a more realistic number than adding up every deal at full value, because not every deal will be won.
The template for thisSmall Business Spreadsheet Bundle $20.30 · 30% off→
The formula
Weighted value of a deal = deal value x win probability
Weighted pipeline = the sum of the weighted values of all open deals
Step by step
- List every open deal with its value and current stage.
- Give each stage a probability, from low for new leads to high for deals in final negotiation.
- Multiply each deal's value by its stage probability.
- Add up the weighted values.
- Compare the total with your target for the period.
- Update the probabilities every few months using your real win rates.
Worked example
| Deal | Value | Stage | Probability | Weighted value |
|---|---|---|---|---|
| Client A | 4,000 | New lead | 10% | 400 |
| Client B | 2,500 | Contacted | 25% | 625 |
| Client C | 6,000 | Qualified | 50% | 3,000 |
| Client D | 1,800 | Proposal sent | 75% | 1,350 |
| Client E | 3,200 | Negotiation | 90% | 2,880 |
| Total | 17,500 | 8,255 |
The unweighted pipeline is 17,500. The weighted pipeline is 8,255, less than half. If your target for the period is 10,000, the full figure says you are comfortably ahead and the weighted figure says you are about 1,745 short and need more deals or need to move existing ones forward.
In a spreadsheet
Keep a small table of stages and probabilities. In the deals list, look up each deal's probability from its stage, and multiply by the value in the next column. The total is a sum of that column. A single formula can also do it in one go by multiplying the value column by the probability column and adding the products.
Where the probabilities come from
Start with rough estimates, then replace them with evidence. For each stage, look back over a few months:
Stage probability = deals that reached this stage and were eventually won / all deals that reached this stage and have closed
If 30 deals reached proposal sent and have since closed, and 12 of them were won, the proposal-stage probability is 12 / 30 = 40%.
You need a reasonable number of closed deals for this to mean anything. With fewer than about 20, treat the percentages as rough.
What the weighted pipeline is good for
- Forecasting income for the next month or quarter.
- Spotting a gap early, while there is still time to find more leads.
- Planning capacity, such as whether you can take on more work.
- Comparing periods. Is the weighted pipeline bigger or smaller than this time last month?
What it is not
It is an average, not a prediction for any single deal. A 6,000 deal at 50% will bring in either 6,000 or nothing, never 3,000. The fewer deals you have, the further the real outcome can land from the weighted number. With five deals, one big win or loss moves everything. With fifty, the average becomes much more reliable.
Pipeline coverage
A related check is pipeline coverage: total open pipeline divided by your target. In the example, 17,500 / 10,000 = 1.75 times. If you historically win about a third of your pipeline by value, you would want roughly three times your target in the pipeline. Your own win rate tells you the ratio you need.
Common pitfalls
- Optimistic stages. A deal sits at negotiation because the last call felt good. Weighted numbers are only as honest as the stages.
- Stale deals. A proposal sent four months ago with no reply is not a 75% deal. Close it or move it back.
- Ignoring close dates. A weighted total is only useful for a period. Filter to deals expected to close in that period.
- One giant deal. If a single deal is half the pipeline, look at the forecast with and without it.
- Never updating probabilities. Default percentages are guesses until your own data replaces them.
- Adjusting the probability by feel on individual deals. If you allow overrides, note why.
How often to review
Weekly is right for most small businesses. Update stages first, then read the weighted total. A forecast built on last month's stages is fiction.
A spreadsheet that weights the pipeline for you
The Content Crib Small Business CRM has a deals list where each stage carries a probability, and it calculates the weighted pipeline from them. It also includes contacts, follow-ups due, an activity log and a monthly report. It works in Excel, Google Sheets and Apple Numbers.

Skip the blank page
The Small Business Spreadsheet Bundle includes the Small Business CRM and Sales Pipeline, laid out and ready to use. $20.30, instant download.
Get the Small Business Spreadsheet BundleRelated guides
- How to Do Bookkeeping for a Small Business (Beginner Guide)
- Cash Basis vs Accrual Accounting: The Difference in Plain English
- Profit and Loss Statement for a Small Business: How to Make One
- Simple CRM Spreadsheet: What to Track and How to Set It Up
- Sales Pipeline Stages Explained (With Examples for Small Business)