Multiple Subtotals in Column separated by formatted rows

[angel585858]

I have a spreadsheet that i need to add multiple subtotals in the same column above ranges of cells separated by formatted rows. The number of rows change every month so it would need to be dynamic.
I am not able to use sumifs as several ranges contain the same description. Is there a formula that can do this?

 

[mrshl9898]

Can you supply some sample data and the result you want to achieve?

 

[angel585858]

Here is an example of what I am trying to do, the subtotals are on top and new lines are added each month so the range is variable.
I am trying to subtotal the lines beneath the blue line until the next blue line.

 

[mrshl9898]

Copying your data, I put "N1" in cell A2.

Try this:

=SUM(INDIRECT(ADDRESS(ROW(A8),COLUMN(C6))&":"&ADDRESS(MATCH(INDEX($A8:$A105,MATCH(FALSE,ISBLANK($A8:$A105),0)),$A:$A,0)-1,COLUMN(C6))))

You'll need to use Shift+Ctrl+ENTER to get it working, then just copy/paste the cell from there

 

[angel585858]

Copying your data, I put "N1" in cell A2.

Try this:

=SUM(INDIRECT(ADDRESS(ROW(A8),COLUMN(C6))&":"&ADDRESS(MATCH(INDEX($A8:$A105,MATCH(FALSE,ISBLANK($A8:$A105),0)),$A:$A,0)-1,COLUMN(C6))))

You'll need to use Shift+Ctrl+ENTER to get it working, then just copy/paste the cell from there

Thanks for your help! This worked great!