VBA use AutoSum Dynamic Range to Create another Function

[DanMor]

I have an autosum function that works well with dynamic ranges and would like to use the output to create another dynamic function.

	C	D	E	F	G	H	I	J	K	L	M
3	7	Project 1
4	2	Project 2
5	3.25	Project 3
6	12.25		12.25
7	4.98	Project 4
8	2.58	Project 5
9	3	Project 6
10	3.92	Project 7
11	14.48		14.50
12	4	Project 8
13	5.5	Project 9
14	9.5		9.50

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Practice​

	C	D	E	F	G	H	I	J	K	L	M
3	7	Project 1
4	2	Project 2
5	3.25	Project 3
6	12.25		12.25
7	4.98	Project 4
8	2.58	Project 5
9	3	Project 6
10	3.92	Project 7
11	14.48		14.50
12	4	Project 8
13	5.5	Project 9
14	9.5		9.50

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Practice​

Worksheet Formulas Cell Formula C6 =SUM($C3:$C5) E6 =CEILING(C:C,0.25) C11 =SUM($C7:$C10) E11 =CEILING(C:C,0.25) C14 =SUM($C12:$C13) E14 =CEILING(C:C,0.25) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

I would like to autosum; M6=sum(F3+G3+H3+I3+K3:L5)
M11=sum(F7+G7+H7+I7+K7:L10)
M14=sum(F12+G12+H12+I12+K12:L13)

Note with this pattern cell C6 sums rows 3 through 5. The last item in cell M6 uses the 3 and 5 and the pattern repeats.

Each week the number of projects changes and the grouping would change. The table always starts with Row 3. But the next week for example could be M8=(F3+...+K3:L7), M15=(F9+...+K9:L14), M21=(F16+...+K16:L20).

Thank you in advance with any help on this.