Home

Need Formula Suggestions / Help

%3CLINGO-SUB%20id%3D%22lingo-sub-1125280%22%20slang%3D%22en-US%22%3ENeed%20Formula%20Suggestions%20%2F%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1125280%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20working%20on%20a%20score%20card%20for%20carriers%20that%20I%20need%20to%20pull%20data%20into.%20I%20have%20everything%20set%20up%20in%20the%20workbook%2C%20so%20won't%20need%20any%20external%20data.%20The%20data%20is%20based%20on%20Date%2C%20Distribution%20Center%2C%20and%20Carrier.%20For%20each%20I%20have%20a%20number%20of%20scheduled%20appointments%2C%20and%20missed%20appointments.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20know%20the%20best%20formula%20to%20count%20the%20number%20of%20scheduled%20appointments%20based%20on%20the%20Distribution%20Center%2C%20the%20Date%2C%20and%20the%20Carrier.%20All%20the%20information%20is%20in%20one%20sheet%2C%20and%20mixed%20together.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20any%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETrey%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1125280%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

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

 

1 Reply
Highlighted

This has been solved, I used SUMIFS.