We need to know how many times an employee has had a specific absence type for each AM and PM shift.
We have 2 worksheets.
The first, called Daily, has a list of employees (col A) with the shift time they were been absent (AM in col E and PM in col F) and the type for that absence (col G). Employees may be listed more than once, as each row is for a date, which is in another column and is irrelevant to the formula.
The second worksheet we are preparing, called Count, lists all company employees (col A) and the total number of Type CO and AN absences.
We need a formula in column G to find the employee name on the Daily worksheet (col A) and count the number of AM shifts (col E, not blank) where the Type is CO or AN (from col G). Then the same for the PM shifts in column H.
I would figure this to be some combination of a VLookUp and CountA, but I have not been able to get anything to work. Any Suggestions?