Hi
I have a work book with 7 worksheets and 1 summary sheet
each work has 3 columns name, late (Y,N), more 15mins(Y,N).
I am trying to count the many times an employees name appears in the
name column over all 7 sheets and ad them to gather in the summary
column against the employees name. eg: if employee 1 is late on day1, day3 and day4 the formula should tcount 3 next to the agents name in the summary sheet tp indicate that the employee was late 3 times in over a week.
next out of those 3 late time I would like to create another formula that will tell me how many times that employee was more that 15mins late.
At the moment I am have only been able to count between sheets using
the counta function but this counts all fields, but I am trying to only count using an employees name as the criteria. So for example in the summary sheet. I enter joe blogs in the A3 (name) I would like the formula in B3 (number of lates) to count the number of times that thats employees name appears on each sheet. Then in C3 (number lates more that 15mins) I would like that formula to count out of the lates how many time the employee was late more than 15mins.
Is this possible?
any help would be great
I have a work book with 7 worksheets and 1 summary sheet
each work has 3 columns name, late (Y,N), more 15mins(Y,N).
I am trying to count the many times an employees name appears in the
name column over all 7 sheets and ad them to gather in the summary
column against the employees name. eg: if employee 1 is late on day1, day3 and day4 the formula should tcount 3 next to the agents name in the summary sheet tp indicate that the employee was late 3 times in over a week.
next out of those 3 late time I would like to create another formula that will tell me how many times that employee was more that 15mins late.
At the moment I am have only been able to count between sheets using
the counta function but this counts all fields, but I am trying to only count using an employees name as the criteria. So for example in the summary sheet. I enter joe blogs in the A3 (name) I would like the formula in B3 (number of lates) to count the number of times that thats employees name appears on each sheet. Then in C3 (number lates more that 15mins) I would like that formula to count out of the lates how many time the employee was late more than 15mins.
Is this possible?
any help would be great