Macro to insert sum function to inconsistent data

[kosherboy]

Hi.
In this workbook SUM EVERY GROUP.xlsx there are many groups of data separated by 3 rows and a text called "total" underneath each group. Since each group is not always the same distance from the previous group therefore it is difficult to write a code in VBA that would detect that specific range of the group and sum it up and continue summing up every following group. I highlighted in yellow all the ranges that need to be summed up via VBA. Again, please keep in mind that these ranges change in size very frequently and therefore the vba code must be very specific.
Any ideas?

Thanks in advance.

[JBeaucaire]

This should do it since those blank rows are there.

Please Login or Register  to view this content.

[kosherboy]

This should do it since those blank rows are there.

Thanks a million, it worked!
Is it possible for you to tweak the code so that i can see the formula? Fir the first sum i got it to work with the formula by incorporating this into your code:

Please Login or Register  to view this content.

However i was having a little trouble with the other two offsets, can you help me with it?

Thanks again

[kosherboy]

I got it!

Please Login or Register  to view this content.

Thanks again for all your help, your knowledge is very appreciated
This thread is solved.

[JBeaucaire]

Well done on the followup solve... thumbs up.