Hi Everyone!
Currently I am working on a project that requires me to manually enter this data every week and I was hoping my wonderful excel friends could help me with a complex count if formula (not sure thats ecactly what I need either)
On the sheet i have the drivers information and below that are two boxes. IN means hired that week OUT mean terminated that week. I want to keep track of this weekly. One box is for type of truck they drive the other is who their FM is. These numbers should match every week. I want a total of every week how many total we have for the catigores for the end of the week and the also the number we have going into next week.
I know that sounds confusing Im sure but hopefuly someone can help me. Any questions feel free to ask!
thanks so much!tracking.xlsx
Bookmarks