Hi,

To sum 4 rows every 48 i'm sure you meant this

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

Mike

"Jarek Kujawa" wrote:

may be this is what yo're looking for:
in C1
=SUM(INDIRECT("B"&(14+48*(ROW()-1))&":B""&(18+48*(ROW()-1)))
in C2
=SUM(INDIRECT("B"&(14+48*(ROW()-1))&":B""&(20+48*(ROW()-1)))

select C1:C2

then drag down


On 14 Mar, 09:58, Jarek Kujawa wrote:
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- Ukryj cytowany tekst -

- Pokaż cytowany tekst -