All,
I have a table (EMP_TASK) with 3 columns (A:A=Task, B:B=Employee, C:C=Hours to Complete). My goal is to auto populate another table (EMP_TOTAL) with the name(E:E=Employee) and sum the total hours (F:F=Total Hours) from EMP_TASK table. Any suggestions, so far the only things I can get are #VALUE ! or #N/A.
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Task[/TD]
[TD]Employee[/TD]
[TD]Hours[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 1[/TD]
[TD]Andrew A[/TD]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 2[/TD]
[TD]Andrew B[/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 3[/TD]
[TD]Andrew C[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 4[/TD]
[TD]Andrew D[/TD]
[TD]20[/TD]
[TD][/TD]
[TD]Employee[/TD]
[TD]Total Hours[/TD]
[/TR]
[TR]
[TD]Task 5[/TD]
[TD]Andrew A[/TD]
[TD]20[/TD]
[TD][/TD]
[TD]Andrew A[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]Task 6[/TD]
[TD]Andrew B[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]Andrew B[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]Task 7[/TD]
[TD]Andrew C[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]Andrew C[/TD]
[TD]32[/TD]
[/TR]
[TR]
[TD]Task 8[/TD]
[TD]Andrew D[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]Andrew D[/TD]
[TD]35[/TD]
[/TR]
[TR]
[TD]Task 9[/TD]
[TD]Andrew A[/TD]
[TD]25[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 10[/TD]
[TD]Andrew B[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 11[/TD]
[TD]Andrew C[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 12[/TD]
[TD]Andrew D[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have a table (EMP_TASK) with 3 columns (A:A=Task, B:B=Employee, C:C=Hours to Complete). My goal is to auto populate another table (EMP_TOTAL) with the name(E:E=Employee) and sum the total hours (F:F=Total Hours) from EMP_TASK table. Any suggestions, so far the only things I can get are #VALUE ! or #N/A.
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Task[/TD]
[TD]Employee[/TD]
[TD]Hours[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 1[/TD]
[TD]Andrew A[/TD]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 2[/TD]
[TD]Andrew B[/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 3[/TD]
[TD]Andrew C[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 4[/TD]
[TD]Andrew D[/TD]
[TD]20[/TD]
[TD][/TD]
[TD]Employee[/TD]
[TD]Total Hours[/TD]
[/TR]
[TR]
[TD]Task 5[/TD]
[TD]Andrew A[/TD]
[TD]20[/TD]
[TD][/TD]
[TD]Andrew A[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]Task 6[/TD]
[TD]Andrew B[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]Andrew B[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]Task 7[/TD]
[TD]Andrew C[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]Andrew C[/TD]
[TD]32[/TD]
[/TR]
[TR]
[TD]Task 8[/TD]
[TD]Andrew D[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]Andrew D[/TD]
[TD]35[/TD]
[/TR]
[TR]
[TD]Task 9[/TD]
[TD]Andrew A[/TD]
[TD]25[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 10[/TD]
[TD]Andrew B[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 11[/TD]
[TD]Andrew C[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Task 12[/TD]
[TD]Andrew D[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]