Heavynbound
New Member
I am trying to create a sum formula that will search within a table and sum the total number of hours for each employee by month by account code. Every SUMIF formula I have tried comes back with an error message or it will only pick up the first row of an employee account code but if the employee have more than one account for a particular month, it omits the second and third row of account hours, if applicable. Here is a sample of my two tables:
ID # Name Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12
111 DUCK, DAFFY 10 4 7 6 11 3
222 DOE, JANE 12 0 9 7 14 6
333 DOE, JOHN 17 11 6 0 8 12
ID Name Account Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12
111 DUCK, DAFFY 1000-000 5 1 3 2 5 1
1000-100 2 1 1 2 4 1
1000-600 3 2 3 2 2 1
222 DOE, JANE 1000-100 7 0 5 4 8 4 1000-600 5 0 4 3 6 2
333 DOE, JOHN 1000-100 17 11 6 0 8 12
Can someone please help me?
ID # Name Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12
111 DUCK, DAFFY 10 4 7 6 11 3
222 DOE, JANE 12 0 9 7 14 6
333 DOE, JOHN 17 11 6 0 8 12
ID Name Account Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12
111 DUCK, DAFFY 1000-000 5 1 3 2 5 1
1000-100 2 1 1 2 4 1
1000-600 3 2 3 2 2 1
222 DOE, JANE 1000-100 7 0 5 4 8 4 1000-600 5 0 4 3 6 2
333 DOE, JOHN 1000-100 17 11 6 0 8 12
Can someone please help me?
