in C1:
=SUM(INDIRECT("B"&(14+48*(ROW()-1))&":B""&(18+48*(ROW()-1)))

however pls pay attention to the fact that B62:B68 does not follow
your desired pattern: "it should calculate the sum range of 4
continuos cells after every 48th
cell..."

On 14 Mar, 09:34, Sasikiran
wrote:
Dear,

I need to drag the formula in a column in such a way that the formula should
proceed in this manner.

SUM(B14:B18)
SUM(B62:B68) * * * *
SUM(B110:B114)

it should calculate the sum range of 4 continuos cells after every 48th
cell...

Hope this is clear

Please suggest