Jan 23 2020 08:09 AM
Hello Everyone,
I am working on a score card for carriers that I need to pull data into. I have everything set up in the workbook, so won't need any external data. The data is based on Date, Distribution Center, and Carrier. For each I have a number of scheduled appointments, and missed appointments.
I need to know the best formula to count the number of scheduled appointments based on the Distribution Center, the Date, and the Carrier. All the information is in one sheet, and mixed together.
Thank you in advance for any help!
Trey
Jan 23 2020 08:12 AM - edited Jan 23 2020 09:34 AM
This has been solved, I used SUMIFS.