Cost per guest divides the all-in event total by headcount — the single number that frames an event’s scale and lets you compare options or trim to a target.
The example
$30,000 for 120 guests.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Total cost | 30000 |
| 3 | Guests | 120 → $250 |
The formula
The formula:
How it works
How it works:
- Divide the all-in cost (catering, venue, rentals, everything) by guest count.
- Flip it to budget:
target_per_guest × guestssizes the total. - Trimming the guest list lowers cost fast — per-guest costs are mostly variable.
- Split fixed vs per-guest costs to see how the number changes with headcount.
Headcount is the biggest lever. Because catering, rentals, and favors scale per guest, cutting the list is the fastest way to hit a budget — far more than haggling vendors. Splitting fixed costs (venue, photographer, DJ) from per-guest costs shows exactly how much each additional guest adds, which makes the “who to invite” decision a numbers conversation.
Try it: interactive demo
Total event cost and guest count.
Variations
Budget from a target
Per-guest goal:
With fixed costs
Fixed + variable:
Guests for a budget
Max headcount:
Pitfalls & errors
All-in cost. Include rentals, favors, gratuity — not just catering.
Zero guests. No headcount gives #DIV/0!.
Fixed vs variable. Per-guest cost falls as guests rise (fixed costs spread).
Practice workbook
Frequently asked questions
How do I calculate cost per guest in Excel?
How do I size a budget from a per-guest target?
How many guests can a budget afford?
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