I have an excel sheet that I would like to have totals for employee hours, sorted by the code that is entered.
Example: For employee 1 there are hours on Tuesday and Wednesday that are coded to 02003 - I would like to make a total sheet that has the employee and the number of hours totaled for each code entered on the first sheet.
I do not know why your spreadsheet layout is this, but probably another type of layout would greatly facilitate you working with payroll data.
I assembled the formulas taking into account exactly this layout.
A formula was made and duplicated for the other days of the week.
You may notice that each formula consists of 5 similar parts changing only the interval references.
Perhaps there is a more elegant way to do this formula.
That's the way I got it now.
"...I tried to just copy and paste the formula but I cannot get it to work, any advice?..."
Possibly when you copy the formula from my example worksheet and paste it into your actual worksheet, the copy is bearing the address of the original worksheet: [16_Fev_2017_Worksheet-OK.xls] This should be the cause of the error.
IF, the other worksheets really have the same layout as the one you sent me to solve, then the CODES tab formula, cell B2 is this: