What is the formula for average deal size in Salesforce?

Total won Amount divided by the number of won deals, written AMOUNT:SUM / RowCount in a summary formula column. The steps are in Salesforce Help: Add a Summary Formula Column .

Why is there no Summarize option on my Amount column?

Summarize only appears on numeric columns. Check that you opened the menu on Amount and not on a text field such as Opportunity Name.

Should average deal size include Closed Lost opportunities?

No. Lost deals never brought revenue, so filter Opportunity Status to Closed Won. Leaving our 4 lost deals in would have raised the average to $65,205.56.

Can I filter a report by a summary formula column?

No. Summary formula columns cannot be grouped, filtered or reordered, as listed in summary formula tips and limits .

Can a Salesforce report show the median deal size?

The Summarize menu offers only Sum, Average, Max and Min, so there is no median option. Sort the detail rows by Amount and read the middle value, or export the report.

Average Deal Size Report in Salesforce (Formula + Steps)

Average deal size in a Salesforce report is the total Amount divided by the number of deals in each group:

AMOUNT:SUM / RowCount

Add it as a summary formula column in an Opportunities report, or skip the formula and pick Summarize > Average on the Amount column. Both return the same number.

We built this average deal size report in Salesforce on 14 Closed Won deals from 2026: $60,092.86 overall and $64,400.00 for new customers. Below are the build, the formula and report variations, and the mistakes that skew the average.

This Tutorial Covers: