How To Sum Every 5 Rows?

[xlmaniac]

Dear All,
I do have a huge data set spread across 1000 of rows.
I would like to add every 5 rows as per following sample.
My Data is across column B & the result should get populated in the column C.
Pls help with the formula.
[TABLE="width: 162"]
<tbody>[TR]
[TD]Amount[/TD]
[TD]Desired Result[/TD]
[/TR]
[TR]
[TD="align: right"]100[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]150[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]70[/TD]
[TD="align: right"]400[/TD]
[/TR]
[TR]
[TD="align: right"]200[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]250[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]300[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]350[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]400[/TD]
[TD="align: right"]1500[/TD]
[/TR]
</tbody>[/TABLE]

 

[sadboy309]

You use formula:

[E6]=IF(MOD(ROW(),5)=1,SUM(D2:D6),"")

As Picture:

 

[xlmaniac]

You use formula:

[E6]=IF(MOD(ROW(),5)=1,SUM(D2:D6),"")

As Picture:

Thank you so much for your help.
Really appreciate the same.
Thanks again.