A family shows up with adults, kids, and a grandparent, each at a different price. Multiply each headcount by its ticket price and add them — one formula rings up any mix at the window.
Four adults, six kids, and no seniors is $48 + $48 = $96 — rung up in one cell.
The example
Three groups, each with a count of adults, kids, and seniors at fixed ticket prices.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Group | Adults | Kids | Seniors | Total |
| 2 | Birthday | 4 | 6 | 0 | 96 |
| 3 | Family | 2 | 3 | 1 | 58 |
| 4 | Seniors trip | 0 | 0 | 8 | 80 |
The formula
Each ticket type is a count times a price; the pieces add together:
How it works
Three little products, one sum:
B2*12charges the adults at $12 each.C2*8charges the kids at $8 each.D2*10charges the seniors at $10 each.- The plus signs add the three subtotals into one group admission — SUMPRODUCT does the same across a price list if you prefer.
Put the prices in their own cells instead of inside the formula so a price change is a one-cell edit.
Try it: interactive demo
Enter the counts; prices are adults $12, kids $8, seniors $10.
Variations
Prices in cells
Point at a price row so a change is one edit.
Group discount
Take 10% off groups of eight or more.
Pitfalls & errors
Do not sum the headcounts and multiply by one price — that charges kids and seniors the adult rate. Each ticket type has to keep its own price in its own term.
Move the prices into labeled cells and reference them. Prices typed inside every formula are easy to miss when you run a summer special and have to change them everywhere.
Practice workbook
Frequently asked questions
Should I use SUMPRODUCT instead?
How do I apply a group discount?
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