Published on December 6, 2007
Theatre Booking System Lesson 3: Using functions with a theatre booking system
1 1. Open up your spreadsheet. 2. In the Number column use the COUNTIF function. This counts how many of a certain number there are in a certain range – e.g. =COUNTIF(B2:H11,1)
2 The function I have entered is = COUNTIF(B2:H11,1) Range Criteria The first part of the function is the range. In the example above it is B2:H11. The second part of the function is the criteria. In the example above it is 1.
3 Now that we have worked out the number of each type of ticket sold, it is time to work out how many we have sold altogether. To do this we use the SUM function. This is what has been entered in cell M9 in the above example.
4 The function I have entered is = SUM(M3:M6) Range If you enter a function similar to the one above you should find that your spreadsheet adds up and displays the total for the range you have specified. Make sure your SUM function adds up the number of tickets sold!
5 Now that we know how many of each type of ticket we have sold and how many in total, it is time to find out how much we have earned! Revenue is a term which means the amount of money made.
6 The formula I have entered is = M3*L3 + (add) - (subtract) * (multiply) / (divide) To work out the revenue for each category, simply enter the Price multiplied by the Number of tickets sold. Do the same for the Total.
6 Make sure your ‘money’ cells are formatted according to currency: Format -> Cells -> Number
Gr.11-Lesson Plans. Gr.12-Lesson Plans Project; HL Only. P2 - News Article Analysis; Strand 2: Application to specific ... 2012 Theatre Booking System ...
Learn how with the bookitlive complete appointment booking system. bookitlive ... 4.5 stars. How to Book a ... or contacts you via bookitlive’s online ...
Seat Booking System For Theatre ... The database contains 4 tables: ... but when i a customer to book a lesson, i want the booking to be not booked twice.
Find and compare Reservations software. ... The most owner-friendly solution for doing 4 things: ... Travel booking system for travel agents, ...
ASL-Interpreted: Guide to Buying Tickets, ... Theatre booking system 3 ... "Buying a plane ticket"talk show in Mandarin Lesson - Duration: ...
Friendship & Enrolment ... BELOW INFORMATION RELATES TO OUR UPCOMING ONLINE BOOKING SYSTEM FOR PAYMENT. ... Group Music or Theatre lesson casual rate $20:
The Book of Mormon, ... Eugene O'Neill Theatre Running Time 2.5 hrs, one intermission Ticket Prices From $99 ...
... 4 días) Enfocado a ... for Travel Agents and the range of Billing Reports issued by BSP in the BSP system. ... Systems Fares and Ticketing Course ...