Sum First 4 cells, next 4 cells, then the next 5 cells

[mboyes7]

Starting at F35, looking to sum the first 4 cells, then in the next cell sum the next 4 cells, then in the next cell sum the next 5 cells in row 35. Then repeat.

If I am summing 4 cells every time, I use the formula below - not sure how to sum 4, 4 then 5 and repeat.

=SUM(OFFSET($F$35,,(COLUMNS($F$35:F35)-1)*4,,4))

Thank you!

 

[DanteAmor]

There is no pattern in the numbering.
In which cells you will put the formulas.
You have something like this:

Hoja12

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD]P[/TD]
[TD]Q[/TD]
[TD]R[/TD]
[TD]S[/TD]
[TD]T[/TD]
[TD]U[/TD]
[TD]V[/TD]
[/TR]
[TR]
[TD="align: center"]34[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]35[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]55[/TD]
[/TR]
[TR]
[TD="align: center"]36[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Formula[/TD]
[/TR]
[TR]
[TD][TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Cell[/TD]
[TD]Formula[/TD]
[/TR]
[TR]
[TD]T35[/TD]
[TD]=SUM(OFFSET($F$35,,0,,4))[/TD]
[/TR]
[TR]
[TD]U35[/TD]
[TD]=SUM(OFFSET($F$35,,4,,4))[/TD]
[/TR]
[TR]
[TD]V35[/TD]
[TD]=SUM(OFFSET($F$35,,8,,5))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[CyrusTheVirus]

Just keep in mind, it's always best to display the exact data showing the expected results. It can help the members with their reply. Unless Dante has already helped, it might be beneficial for you to post a sample of your data for viewing purposes.

 

[mboyes7]

Thank you! That works!
I will make sure to post an exact example next time.

 

[DanteAmor]

You're welcome. Thanks for the feedback.