Help with Subtotal, CountIf, and Sum Product

[lizdraya]

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

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

[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,

 

[jtakw]

Yes, thank you so much for your explanation.

I noticed that excel slowed down like Windows 95 with the OFFSET calculations and I tried your new version.

You're welcome, so I guess it's working properly.