Average deal size 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 | Revenue from won deals ($) | 450000 | 450000 |
| B3 | Deals won | 30 | 30 |
| B5 | Average deal size ($) | =ROUND(B2/B3,0) | 15000 |
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 average deal size?
- Divide the revenue of the deals you won by the number of those deals. $450,000 across 30 deals is an average deal size of $15,000.
- Should I use the average or the median?
- Report both if a few very large deals exist. One enterprise deal can double the average and hide that most deals are getting smaller.
- How can I increase deal size?
- Sell to the right size of company, price by value (seats, usage, outcomes), offer packages instead of single products, and avoid discounting before the buyer asks.
- Is average deal size the same as average transaction value?
- They use the same maths: revenue ÷ number of sales. B2B sales teams say average deal size and count won deals; retail and e-commerce say average transaction value (or average order value) and count purchases.
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.