Excel: Help! Need to Count up to a maximum number, and multiple by price

Hi there, I need some help with a formula, been trying to figure this out but can't seem to get it right (Preferably no VBA). [IMG][IMG]http://s22.postimg.org/h16iyyg5p/Tickets.jpg[/IMG][/IMG] I need to calculate the expected revenue of ticket sales. Few things to note: 1.) Ticket sales start from cheapest to most expensive so once the $200 one is sold out, the $300 tickets will be on sale next. 2.) Expected sales is 80% of the total number of tickets. Is there a way to calculate this via a single formula? So if my expected sales of 225 (Event A), it would count up till the $700 price point with 4 tickets sold at said price point. Hence, expected revenue would be tickets sold (number) x price it was sold at ($). Any ideas? Any help would be much appreciated!

This question generated 8 answers. To proceed to the answers, click here.

This thread is current as of October 26, 2014.

For more resources for Microsoft Excel