Too few bartenders and the line backs up; too many and the event overpays. Divide the guest count by how many one bartender can comfortably serve, round up, and staff the bar to the crowd.
120 guests at 75 per bartender needs two behind the bar — one would leave a line all night.
The example
Three events, each with a guest count and how many guests one bartender can serve.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Event | Guests | Per bar | Bartenders |
| 2 | Wedding | 120 | 75 | 2 |
| 3 | Cocktail | 60 | 75 | 1 |
| 4 | Gala | 300 | 75 | 4 |
The formula
The ratio seldom divides evenly, so round up to keep the line moving:
How it works
A staffing ratio, rounded for reality:
B2/C2divides the guest count by how many guests a single bartender can serve.ROUNDUP(...,0)rounds up to the next whole bartender — a fraction of a person cannot work a bar.- Guests-per-bartender drops for a full open bar and rises for beer-and-wine only — set it to your service style.
- For a cash bar or a signature-cocktail service, tighten the ratio; those slow the line down.
Add a barback for every two or three bartenders on large events by layering a second ratio on top.
Try it: interactive demo
Enter the guest count and how many guests one bartender can serve.
Variations
Add barbacks
One barback for every two bartenders on a big event.
Staffing cost
Multiply bartenders by an hourly rate and the event length.
Pitfalls & errors
Rounding down understaffs the bar — 120 guests at 75 each is 1.6, and a single bartender means a line all night. Always round up so the crowd is covered.
Lower the guests-per-bartender for a full open bar with mixed cocktails. Complex drinks take longer, so the same crowd needs more hands than a beer-and-wine service would.
Practice workbook
Frequently asked questions
How many guests can one bartender serve?
Should I round the staff up or down?
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