Hi, please I need you help with a formula that counts the number of working days for each driver
As you can see in the attached file, the main sheet contains all the driver's emp # and names, on the top of each column I added the date, and the second row contains the area, where each trip came from
I have only two areas so I can add for each driver in the specific date how many trips from each area (if there is)
Then, in a separate column I sum all the trips from each area alone, and one more column to check how many days each driver work during this month
Ex: first driver works for 3 days, (first day has trips from both areas which counts only 1, so in this case I can't use counta for all the range D3:M3 since I will get 4, so I added another formula as in column T..., check each day if there is a trips or not and then use the sum function in the working days column
Please help me getting better solution to get the working days directly in the required column without adding the last functions as in column T, or if you have a better way to record these data this will be highly appreciated
Trip file
As you can see in the attached file, the main sheet contains all the driver's emp # and names, on the top of each column I added the date, and the second row contains the area, where each trip came from
I have only two areas so I can add for each driver in the specific date how many trips from each area (if there is)
Then, in a separate column I sum all the trips from each area alone, and one more column to check how many days each driver work during this month
Ex: first driver works for 3 days, (first day has trips from both areas which counts only 1, so in this case I can't use counta for all the range D3:M3 since I will get 4, so I added another formula as in column T..., check each day if there is a trips or not and then use the sum function in the working days column
Please help me getting better solution to get the working days directly in the required column without adding the last functions as in column T, or if you have a better way to record these data this will be highly appreciated
Trip file