Average ticket is total revenue divided by clients served — the typical spend per visit. Raising it (add-ons, retail, upgrades) grows revenue without needing more clients.
The example
$9,200 across 80 clients.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | 9200 / 80 | — |
| 3 | Avg ticket | → $115 |
The formula
The formula:
How it works
How it works:
- Sum all revenue — service and retail — over the period.
- Divide by clients served for the average ticket.
- Split into service ticket and retail ticket to see where to grow.
- Lift it with add-ons, upgrades, and retail — each raises the same denominator’s value.
Average ticket scales without more chairs. Adding $10 to every ticket at 80 clients a week is $800/week — $40k+ a year — from the clients you already have. That’s why add-on services, retail attach, and service upgrades beat chasing new traffic: the marginal cost is tiny and the chair time barely moves. Track service vs retail ticket separately to aim the effort.
Try it: interactive demo
Total revenue and clients.
Variations
Service ticket
Service only:
Retail ticket
Retail per client:
Revenue at a target ticket
Plan growth:
Pitfalls & errors
Count clients, not visits. Decide whether repeat visits in the period each count.
All revenue. Include retail if you want the full ticket.
Zero clients. No traffic gives #DIV/0!.
Practice workbook
Frequently asked questions
How do I calculate average ticket in Excel?
How do I split service and retail ticket?
Why focus on average ticket?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class