I have a business that customers frequent. I need a formula on excel that I can input date to determine if a customer comes in (example) 8 times a year instead of 6 how much income is produced. I can change the fields.
1. Average monthly spent by customer. 2. How many customers. 3. Frequency of visit 4. Multiplied by how many employees.
Skills: microsoft excel