Hi guys,

I want to create continuous formulas in one column (see variables below). Has anyone got a code for this? thanks
[A1]
=SUM(BO2:BO32)
=SUM(BP2:BP32)
=SUM(BQ2:BQ32)
....
=SUM(CR2:CR32)
=SUM(CS2:CS32)
...after 31 rows change in row number
=SUM(BO33:BO63)
=SUM(BP33:BP63)
=SUM(BQ33:BQ63)
.....
=SUM(CR33:CR63)
=SUM(CS33:CS63)
...after 31 rows change in row rumber again
=SUM(BO64:BO94)
....