How to calculate a weighted sales forecast
Calculate an estimate for a specific month from open deals. See exactly what to change when the buyer moves a decision into the next month.
1,000 credits + 7 days full accessOn first app sign-in · Once per device · No card required
Choose the period and include open opportunities with an expected close date in that period. Multiply each deal’s amount by its chance of winning within that period, then add the results. Show won deals separately and recalculate when an expected close date changes.
Start with the deals that could close in the reporting period
Take a snapshot on a stated date. For a June forecast, select open opportunities expected to close in June. Give deals with a missing decision date their own line for review.
Use one definition for the amount, such as the value of the initial order, and one currency. If a deal has alternative quotes for the same purchase, use the amount for the current working scope once.
In this guide the estimate covers the value of future orders that may be won in a period. Use a separate schedule for invoices or cash receipts.
Multiply each deal amount by its probability
Weighted deal amount = deal amount × probability. The weighted forecast is the sum of the weighted amounts for eligible open deals.
| Open opportunity | Order amount | June win probability | Weighted amount |
|---|---|---|---|
| Label print order | $12,000 | 50% | $6,000 |
| Warehouse signage | $8,000 | 25% | $2,000 |
| Site maintenance | $5,000 | 80% | $4,000 |
| Open total | $25,000 | $12,000 |
Copy the eligible opportunities to their own range. Enter amounts in B2:B4 and probabilities as percentages in C2:C4. Use **=SUMPRODUCT(B2:B4*C2:C4)** or multiply each row and sum the result.
Use a comparable past group to estimate the chance of winning
For a stage estimate, take old snapshots at a similar point in the month. Group comparable opportunities by their stage at the snapshot. Count how many won within the target period and divide by all comparable deals that were open in that group at the snapshot.
Once the historical period ends, an opportunity still open after the cutoff counts as a deal that did not win within that period. For example, if 4 of 10 comparable open quotes won by the end of the month, the estimate from that group is 40%. With sparse history, mark your first estimate as an assumption and keep the sample size visible.
Record the reason for an individual exception. For example, the buyer may confirm the decision will move beyond the cutoff. Update the date first when the reporting period changes.
Move the deal to the period where the buyer expects to decide
| June view | Before the date change | After the date change |
|---|---|---|
| Open order total | $25,000 | $17,000 |
| Weighted open amount | $12,000 | $10,000 |
| Orders already won in June | $3,000 | $3,000 |
| Won plus weighted open estimate | $15,000 | $13,000 |
The signage deal contributed $2,000 to the June weighted amount. Remove it from June and reassess its likelihood in July. The $3,000 already won stays outside the open calculation.
Keep a note that explains the difference between snapshots
Context
“The buyer moved the warehouse signage decision from June to July.”
Forecast note
June weighted open forecast is $10,000. The previous snapshot showed $12,000. Signage moved to July after the buyer confirmed a later review date. Actual June wins remain $3,000. Check the new decision date in the next review.
Save the snapshot date, the input that changed and the reason.
Review the estimate and the largest assumptions together
Keep the original snapshot.
Record its date, period, included deals and probabilities so you can reproduce the total later.
Review large opportunities separately.
Show what the total would be if a large deal slips or closes. Use the buyer’s latest decision evidence when choosing the scenarios.
Compare the same measure after the cutoff.
Compare the snapshot’s won plus weighted open estimate with the value of orders actually won in the same period. Keep a note if new deals appeared after the snapshot.
When you have too few records for credible probabilities, show the named deals and plausible scenarios side by side. A weighted total is easier to use when the reader can inspect the assumptions behind it.
Frequently asked questions
Keep the period, deal values and probabilities consistent.
What is a weighted sales forecast?
It adds up open deal amounts after multiplying each one by its estimated chance of winning within the chosen period.
How do I calculate it in Excel?
Copy the eligible open deals into their own range. Enter their amounts and probabilities as percentages, then use SUMPRODUCT to add their row-by-row products.
Which date determines if a deal is included?
Use the expected decision or close date for the deal and the start and end dates of the period. Review missing dates separately.
Do closed-won deals go into the weighted amount?
Show won amounts in their own line. Add them once if your report also shows an estimate for the full period.
How do I choose a stage probability?
Start with comparable historical deals from the same stage and a similar time horizon. Use their share of wins within the cutoff or clearly label your starting assumption.
How do I handle different currencies?
Convert to one reporting currency using a documented rate and date, or show separate forecasts per currency.
Sources and example notes
All opportunities, amounts, dates and probabilities are fictional. The calculation can be done by hand or in a spreadsheet.
- Pipedrive · Probability in Pipedrive
The weighted value formulas explain how amount and deal or stage probability combine.
- Microsoft Support · SUMPRODUCT function
The spreadsheet example uses SUMPRODUCT to add the amount multiplied by probability for each row.
