Can you provide the excel formula how to count the daily traffic and average ticket price?

Sure, I can help with that. Here's how you can do it:

1. Counting Daily Traffic: Assuming your data is in column A and each entry represents one unit of traffic, you can use the COUNT function to count the daily traffic. If your dates are in column B, and you want to count the traffic for a specific day (let's say 1st Jan 2022), the formula would be:

=COUNTIF(B:B, DATE(2022,1,1))

This formula counts the number of times the date 1st Jan 2022 appears in column B, which represents the daily traffic for that day.

2. Calculating Average Ticket Price: Assuming your ticket prices are in column C, you can use the AVERAGE function to calculate the average ticket price. The formula would be:

=AVERAGE(C:C)

This formula calculates the average of all the values in column C, which represents the average ticket price.

Remember to replace the column letters and date in the formulas with the ones that match your data.