I have a file that contains hours by department by job code down to the earnings code level. What I am trying to do is sum up in separate columns: worked hours, paid hours and Overtime hours.</SPAN>
I have a separate table that tells me which earnings codes counts towards Worked/Paid/OT.</SPAN>
So if I am trying to sum worked hours I need to go to the earnings code file column D, if that is “True” go over to the respective row take that number and find it on the main sheet column F and sum column I</SPAN>
This is what i have:
=SUMIFS(I:I,'[Earnings Codes.xlsx]Sheet1'!$D:$D,"TRUE",F:F,'[Earnings Codes.xlsx]Sheet1'!$B:$B)</SPAN>
but the number I am getting, is no where near close to what it should be.
I have a separate table that tells me which earnings codes counts towards Worked/Paid/OT.</SPAN>
So if I am trying to sum worked hours I need to go to the earnings code file column D, if that is “True” go over to the respective row take that number and find it on the main sheet column F and sum column I</SPAN>
This is what i have:
=SUMIFS(I:I,'[Earnings Codes.xlsx]Sheet1'!$D:$D,"TRUE",F:F,'[Earnings Codes.xlsx]Sheet1'!$B:$B)</SPAN>
but the number I am getting, is no where near close to what it should be.