sum rows based on sub-total

Hello Excel Gurus,

I'm looking for a formula or vba code that will calculate a total (or sub-total to be more precise) for rows that are constantly changing (i.e. dynamic range).

I have attached a spreadsheet for more information which is like a payroll time sheet.

In it, I have to go to each 'sub-total' row to calculate the sum for the activity for that particular location. As there are hundreds/thousands of rows I have to repeatedly hit the sum function for every sub-total line.

I've currently done this in cells:

F9 and G9
F20 and G20
F24 and G24
F32 AND G32

I'm wondering if there is an easier way to calculate all the rows that have a sub-total as an identifier. Either in the form of a formula/vba-code?

Any help would be appreciated.

Unfortunately pivot table will not work in this situation as the report has the sub-total rows in it already but it does not calculate the totals so I have to manually sum the rows. Pivot table could work but then that would require me to delete all the sub-total rows and cleaning a lot of other data on the sheet which will take too much time.

When I drag down the formula in Column H as you suggested, the solution works well for the first sub-total row but for every consecutive sub-total row it subtracts the two columns from each other and
results in a running-total.

I would require only a total for each sub-total line not the running total of each columns. So the sub-total I'm looking for is in Column F and G.

See attached.

nigelbloomy that solution works great thank you so much! oeldere, i would definitely prefer using pivot-table any time but a formula is more suitable for this problem as the data is not in a clean data set and there would be a lot of deleting/cleaning required in order for it to work in a pivot table. That's not to say it can't, it's just it would take too long so formula works better.

Here's a quick one-off method
Filter and delete all rows with Sub-total in column A
Highlight the entire range of data, click Subtotal on the Data Tab
Check both columns F and G (Regular total and Overtime total)
Click OK

Thanks for your help folks. I think all methods suggested work now. Really appreciate it!