Sum of a dynamic number of rows

[LeeB123]

Hello,

My first post. Currently, I manually paste in my formula for each month to calculate the sum of the "Count" rows and then manually update the range of rows (N4:N6 etc). This is a pain and I am sure it can be easier.
The screen shot is an example, but in reality there are often thousands of rows, making the setting of the row range time consuming and prone to errors. The observation is that the header of the rows is always the same, set to "Count" in the example.

In laymen's terms, I need to dynamically adjust the range according to whether the "Count" header is for that particular month.
For example, pasting the dynamic count formula in to cell N33, I would want it to find the "Count" header of cell N22 and therefore chose the range of N23:N32 dynamically.

Many thanks in advance to you clever folks.

Lee

 

[Peter_SSs]

Another vba option assuming the numbers in column N are not the result of formulas

Sub Insert_Formulas()
  Dim rA As Range
  
  For Each rA In Columns("N").SpecialCells(xlConstants, xlNumbers).Areas
    rA.Cells(rA.Count + 1).FormulaR1C1 = "=SUM(R" & rA.Row & "C:R[-1]C)"
  Next rA
End Sub

If the col N values are the result of formulas

For Each rA In Columns("N").SpecialCells(xlFormulas, xlNumbers).Areas