Calculating Subtotals

Hello,

This is my first time posting in a forum. Usually i can find the formula i require.

I'm looking for a subtotal in the blue lines with red borders (the other totals came from a pivot table but column G is a formula). There are also thousands of lines in the actual book and hundreds of subtotals.

I've tried sumproduct and sumifs but i might have been doing them wrong.


Excel help.xlsx

Hi Citylemon
See attached excel file with my solution. Hope it will works properly

If i have several quarters there was only Q1 in the example. Can i use the same helper column or do i have to a helper column per?

Thanks!