Excel IF functions

**Lyndakj** · 10-21-2014, 07:16 AM

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’.

**mcmahobt** · 10-21-2014, 08:59 AM

Can you post a sample workbook?

**Lyndakj** · 10-22-2014, 06:29 AM

Here I have provided a very simple example.
The days across the top are for the whole year however the example only includes a portion of July.

**mcmahobt** · 10-22-2014, 09:05 AM

Based on your information, as far as I know (and without getting real messy), the logical way to do this is through a mega formula that involved OFFSET, MATCH, ADDRESS, and INDIRECT. Someone more skilled may be able to add in their two cents, but I would cross post this to the VBA forum and see what help you could get there.