This sounds like a great use case for Solver, especially since the goal is to optimize the pricing rather than rely on trial and error. I’d make the six ticket prices the changing variable cells and have the target cell calculate total revenue (or profit, depending on the exact objective). Then...
