Revenue per shoot — total revenue over shoots booked — and average profit per shoot tell you which session types and price points actually build the business.
The example
$24,000 over 40 shoots.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | 24000 / 40 | — |
| 3 | Per shoot | → $600 |
The formula
The formula:
How it works
How it works:
- Divide total revenue by shoots booked for average revenue per shoot.
- Use AVERAGEIF by session type to compare weddings, portraits, and minis.
- Subtract average cost for profit per shoot — the number that ranks session types.
- Multiply by target shoots to forecast revenue.
Average per shoot exposes your real product mix. A studio “doing well” on volume might be averaging $300/shoot on draining mini-sessions while a handful of $2,000 weddings carry the profit. Splitting revenue (and profit) per shoot by type with AVERAGEIF tells you which work to chase and which to retire — the headline total hides that completely.
Try it: interactive demo
Total revenue and shoots.
Variations
By session type
Compare offerings:
Profit per shoot
Net the cost:
Revenue forecast
Plan the year:
Pitfalls & errors
Count shoots, not sessions. Decide what one shoot means consistently.
Revenue vs profit. Per-shoot profit ranks types better than revenue.
Zero shoots. No bookings gives #DIV/0!.
Practice workbook
Frequently asked questions
How do I calculate revenue per shoot in Excel?
How do I compare session types?
Why look at profit per shoot, not revenue?
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