HI,
I need help... on column A2 I have the result of 6 drivers that are registered based on 6-course category (A1, A2, B1, B2, C1, C2). the daily attendance are listed from F4:k9)
On the column D4:d9, I have result of the daily attendance, weekly total for Absent only
On the column e4:e9, I have the result of the daily attendance, the weekly total for Duty only
Now, what I need is:
1. on the column B2, to count me how many days the student is absent based on the category A1, B1, C1 ( on the columns b4:b9), only for absent (result from column D4:D9), the correct result should be 4
2. on the C2, to count me how many days the student was on duty based on the result on columns E4:E9, the correct result should be 3
see the pic1 for more clarification.
thuoughts...
I need help... on column A2 I have the result of 6 drivers that are registered based on 6-course category (A1, A2, B1, B2, C1, C2). the daily attendance are listed from F4:k9)
On the column D4:d9, I have result of the daily attendance, weekly total for Absent only
On the column e4:e9, I have the result of the daily attendance, the weekly total for Duty only
Now, what I need is:
1. on the column B2, to count me how many days the student is absent based on the category A1, B1, C1 ( on the columns b4:b9), only for absent (result from column D4:D9), the correct result should be 4
2. on the C2, to count me how many days the student was on duty based on the result on columns E4:E9, the correct result should be 3
see the pic1 for more clarification.
thuoughts...