Hi all,
In Column F, I am manually suming the units of the hours worked (column c) for each individual employee (column a) each week end date (column b). So for example, this is tedious as there are 4000+ rows to go through. I want to automate summing all of the hours for week ending 1/3 for Susan Appleton, which totals 4.5 hours (cell F4). For Susan, there three rows included in this array. I also want to sum all of the hours for week ending 1/3 for Tom Arjangian, which totals 32 hours. For Tom, there are only two rows included in this array. Because the number of rows affected changes from person to person, it won't work to copy and paste down the formula. This is why I have to manually enter it...any ideas on how to automate this? See below for example:
A B C D E F 1 Person Week Ending Date Hours Non-Hours Time Off Hours SUM FORMULA 2 Appleton, Susan 1/3/2016 4.5 0 0 3 Appleton, Susan 1/3/2016 0 27.5 0 4 Appleton, Susan 1/3/2016 0 0 8 4.5 5 Arjangian, Tom 1/3/2016 32 0 0 6 Arjangian, Tom 1/3/2016 0 0 8 32 7 Babcock, Daniel 1/3/2016 32 0 0 8 Babcock, Daniel 1/3/2016 0 0 8 32 9 Appleton, Susan 1/10/2016 5 0 0 10 Appleton, Susan 1/10/2016 4 0 0 11 Appleton, Susan 1/10/2016 2 0 0 12 Appleton, Susan 1/10/2016 0 8 0 11 13 Arjangian, Tom 1/10/2016 40 0 8 40 14 Babcock, Daniel 1/10/2016 2 0 8 15 Babcock, Daniel 1/10/2016 4 0 0 16 Babcock, Daniel 1/10/2016 3 5 0 9
right now to get the above, I am manually entering in =sum(C2:C4) to get Susan Appleton's total hours in F4. This includes 3 rows (rows 2, 3, 4)... then in F6, I manually typed in =sum(C5:C6) which includes 2 rows (rows 5 & 6). Because the # of rows is constantly changing, i don't know how to automate this process.
Any ideas? Help?
Thank you in advance for all of your amazing help!
Bookmarks