Sum Variable Range

I feel like I have searched everywhere and tried all of the other posted examples to the best of my ability; so I'm finally asking for help.

I am in need of code to sum the above range. But it is different range every day. My company will add the deposit amounts each day from each deposit sheet.

ie:
48000
80000
12000
3000





200
45000
10000





And so on. I have posted an example spreadsheet if needed. (The portion is green is all that needs to be summed but keep in mind it changes amount of rows included changes each day, and the yellow is where the solution goes, but I can easily change that). There are other formulas needed but I have figured those out. I need to run this macro daily just for the last group. My brain is exhausted. Please help!
Thanks so much in advance.

My code:

Please Login or Register  to view this content.

Do you want the formula in the cell or the result

Perhaps:

Please Login or Register  to view this content.

Edited...

Sorry, I did a late edit of the sub routine... it would insert a subtotal for each group of Deposit Amounts... maybe you can work from that... I'm not really sure what you want to do... perhaps you only ever want to insert the formula for the last block as and when invoked ?