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.

Amount	Desired Result
100
50
30
150
70	400
200
250
300
350
400	1500

<tbody>
</tbody>

 

[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.