I have two tabs 'Attendance' and 'Operations'.
In the first tab I have every day of the month running along the top. Column A, I have a list of employees.
For each day I have put in the hours they have worked for that particular day and this automatically turns green.
In column B I have the employees discipline i.e Installation.
I need a formula which will allow the following:
- Will read the rows that have ‘installation’ in column B and add up the total hours in a particular week (week x) on that row that the word ‘installation’ was found.
This total will go into tab 2 under ‘installation’ and Week X
Note: the days are not grouped into weeks, just have cells from Monday to Tuesday.
Is this possible without a macro?
I have got it working but it only adds up the first row that contain ‘installation’.