Figure how many tables an event needs: divide guests by seats per table and round up. Add head-table and vendor seats, and you have the floor plan’s backbone.
The example
132 guests, 10 per table.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | 132 / 10 | 13.2 |
| 3 | Tables | → 14 |
The formula
The formula:
How it works
How it works:
- Divide guests by seats per table (8 or 10 are common for rounds).
ROUNDUP(…, 0)ensures a chair for everyone — never round down.- Add a head table and any vendor/gift tables separately.
- Check the venue’s capacity: tables × (table footprint) must fit the room.
Fewer seats per table feels better. Cramming 12 at a 10-top saves a table but tightens elbows and sightlines. Seating 8 at a 10-top is roomy but adds tables (and linens, centerpieces, space). The formula scales instantly — try 8, 9, and 10 per table to balance comfort, the venue’s footprint, and rental cost.
Try it: interactive demo
Guests and seats per table.
Variations
Empty seats
Slack at tables:
Plus head & vendor
Extra tables:
Linens needed
One per table:
Pitfalls & errors
Round up. Rounding down leaves guests standing.
Add special tables. Head, gift, vendor, and kids’ tables are extra.
Check the room. Tables must physically fit the venue footprint.
Practice workbook
Frequently asked questions
How do I calculate tables needed for an event in Excel?
How many seats per table should I use?
How do I include head and vendor tables?
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