Hello all,
I've been a long time lurker here, and you guys have been such a great help. However, I'm biting the bullet and made an account for the first time because I am completely lost. I consider myself a beginner in excel, I would not want to learn any Pivot tables or macros for this task. Here is the information:
I am using Excel 2010
[tr]
Ideally, I would like Excel to sum Regular Hours Paid + Overtime Hours Paid for each employee corresponding to their week ending for all the locations they have worked in .....row 6, Column H
I know, I can use the Subtotal Formula on the top, but I will add weeks to this and other people, so a formula would be ideal (one that does not remove everything]
Currently I am using
=IF(COUNTIFS(B:B,B2,C:C,C2),D2:F2,FALSE))
But, I would like a formula to subtotal it for me , so I have 1 row for Total Hours Paid
Please help,
I've been a long time lurker here, and you guys have been such a great help. However, I'm biting the bullet and made an account for the first time because I am completely lost. I consider myself a beginner in excel, I would not want to learn any Pivot tables or macros for this task. Here is the information:
I am using Excel 2010
Column A | Column B | Column C | Column D | Column E | Column F | Column G | Column H |
Location | Week Ending | Employee Name | Regular Hours Paid | Pay Rate | Overtime Hours Paid | Overtime Rate | Total Hours Paid |
New York | 10/31/2015 | Joe | 20 | $10.00 | 5 | $15 | |
Texas | 10/31/2015 | Joe | 10 | $8.00 | |||
Florida | 10/31/2015 | Joe | 15 | $10 | |||
Ideally, I would like Excel to sum Regular Hours Paid + Overtime Hours Paid for each employee corresponding to their week ending for all the locations they have worked in .....row 6, Column H
I know, I can use the Subtotal Formula on the top, but I will add weeks to this and other people, so a formula would be ideal (one that does not remove everything]
Currently I am using
=IF(COUNTIFS(B:B,B2,C:C,C2),D2:F2,FALSE))
But, I would like a formula to subtotal it for me , so I have 1 row for Total Hours Paid
Please help,